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 “defoamer” 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.

109 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
defoamer1427621(None) 
defamer132710321def_amer
defoamed15356241defoamed
defoamers15285251defoamers
deformer14247941deformer
defacer132810362def_acer
defame123212432def_ame_
defamed14309832def_amed
defamers14258522def_amers
defames132812252def_ames
defeater122611662defeater
deflater123211602deflater
defoam1238562defoam__
defoams1336192defoam_s
defogger1443532defogger
deforcer14246902deforcer
deformed15248262deformed
deformers15266532deformers
defrayer1534932defrayer
dewormer14256322dewormer
foamer114714312__foamer
reformer13217952reformer
befouler1343923befouler
deader84220473de__ader
deafer104114813de__afer
dealer74122143de__aler
dearer74822803de__arer
debaser103510413de_baser
debater104114693de_bater
deboner103110483debo_ner
decayer13339353de_cayer
declaimer1444233declaimer
declarer1148073declarer
decoder113712293deco_der
decoyer13348683deco_yer
deface123113863def_ace_
defaced142910973def_aced
defacers14237993def_acers
defaces133213403def_aces
defeated132812163defeated
defeaters13289103defeaters
defender1337293defender
defer94619753def___er
deferrer12135593deferrer
deffer134411303def__fer
defier105118653def__ier
defiler113911883def_iler
definer114413773def_iner
deflate113613943deflate_
deflated133412303deflated
deflaters13298703deflaters
deflates123013943deflates
deflator12328343deflator
deflower15126083deflower
defoaming1645653defoaming
defogged1533783defogged
defoggers1543053defoggers
deforce13267243deforce_
deforced15247373deforced
deforcers15265503deforcers
deforces14248403deforces
deform1259623deform__
deforms1337803deform_s
defragger1542603defragger
defrauder1442533defrauder
defrayed1635403defrayed
defrayers1644173defrayers
defroster1343903defroster
defter104215923def__ter
defuser115110503def_user
degame102713183de_game_
degames113312623de_games
degrader11247913degrader
dehorner1235523dehorner
delayer113010533de_layer
delouser936363delouser
deporter1169393deporter
deposer104011843depo_ser
depraver1435413depraver
desolater1038383desolater
devourer1235063devourer
devouter1235513devouter
dewater112912423de_water
dewormed15236223dewormed
dewormers15255193dewormers
dormer94415903d__ormer
dreamer104110843d_reamer
effacer15255413_effacer
flamer114919123__flamer
foamed126014403__foamed
foamers123812103__foamers
foamier12339003__foamier
former114221403__former
framer114817443__framer
inflamer1356123inflamer
informer13227283informer
metamer1139613me_tamer
performer16145133performer
reamer84325213re__amer
reformed14249603reformed
reformers14246403reformers
reframe1239393reframe_
reframed1437853reframed
reframes1338993reframes
reloader937913reloader
roamer84715163__roamer
seamer84223613se__amer
tetramer1046813tetramer
venomer1237583veno_mer

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.436409841.7
2DLD Change Limit1461621096.97020970.2
3Display Results1091090.0432534.9
 (SQL Overall)1786911097.44923988.6
 
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.