Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “departee” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
departee113972(None) 
departed1238821departed
departees1265721departees
deportee11510351deportee
repartee10312751repartee
depart94720562depart__
departs104310682depart_s
departure1243802departure
deported1249702deported
deportees1256642deportees
deporter1169392deporter
repartees1147252repartees
biparted1335133biparted
darted84620923d__arted
darter75320363d__arter
dartle73714833d__artle
dearer74822803de_ar_er
dearie73319813de_ar_ie
dearies83526273de_aries
dearth104212513de_art_h
dearths11498843de_arths
debarked16175823debarked
debarker15155503debarker
debarred12165633debarred
debate94419193deba_t_e
debated113916083deba_ted
debater104114693deba_ter
debates103718533deba_tes
decanted122310493decanted
decanter112510793decanter
decare93919153decar__e
decares102818533decar_es
decree93117783de_cr_ee
defatted1335673defatted
degree82814853de_gr_ee
dehorted1357303dehorted
dekare112811563dekar__e
dekares122710873dekar_es
delate73827753dela_t_e
delated93722873dela_ted
delates83526283dela_tes
demarche1645533demarche
demarked16187223demarked
demasted1238763demasted
depainted1375843depainted
departing1349513departing
department1546813department
departures1343533departures
depermed1436453depermed
depicted1437743depicted
depicter1356853depicter
deplete103010423deplet_e
depleted12258723depleted
depleter11298863depleter
depletes112810643depletes
deport94922393deport__
deporters1277793deporters
deports105012883deport_s
deprave1337073dep_rave
depraved1535543depraved
depraver1435413depraver
depraves1436873depraves
deprive1338303dep_rive
depurate1139983depurate
depurated1338183depurated
depurates1239823depurates
depute94512303dep_ut_e
deputed114610173dep_uted
deputes104911783dep_utes
derate74531233dera_t_e
derated93623503dera_ted
derates84028893dera_tes
deratted1048403deratted
desalted1038313desalted
desalter938363desalter
deserted101012203deserted
deserter91211603deserter
detainee92511723detainee
devotee113811823de_votee
dewater112912423dewa_ter
disparted1338853disparted
draftee11379523d_raftee
ecarte84313503_ecart_e
ecartes94212563_ecartes
hearted113314023he_arted
hearten102411753he_arten
imparted13248063imparted
imparter12357543imparter
legatee82814633lega_tee
pardee93922023__pardee
parted94228683__parted
pattee84323383__pattee
pearter9412743pe_arter
reparked15208923reparked
repasted112611533repasted
reported11312703reported
reporter10411423reporter
separate10310783separate
separated1237713separated
separates11310743separates
unparted11310823unparted

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.406440125.6
2DLD Change Limit1461621016.78321548.3
3Display Results1011010.0303366.7
 (SQL Overall)1786911017.21924752.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.