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 “composter” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
composter1536956(None) 
composer145012951compos_er
composted16378811composted
composters16388321composters
comforter16255982comforter
compacter17257882compacter
completer153310412completer
comported16319532comported
compose135716662compos_e_
composed154612062compos_ed
composers153910622compos_ers
composes145017112compos_es
composite15410152composite_
composited1756002composited
composites1648902composites
compositor1644632compositor
compost134515352compost__
composts144210912compost_s
composure1545122composure
compote135616462compo_te_
compotes144716512compo_tes
computer144511512comp_uter
imposter12288162_imposter
bombaster1543803bombaster
booster94314553bo__oster
coaster94219043co__aster
cocomposer1853323cocompos_er
cohosted1436133co_hosted
colporteur1451873colporteur
combater1439383com_bater
combusted1644643combusted
combustor1543703combustor
comforted17315963comforted
comforters17275193comforters
commenter151410693commenter
commoner142710633commo_ner
commuter143010153com_muter
comose105016843com_os_e_
compacted18297363compacted
compacters18247023compacters
compactor17256023compactor
comparer143611363comp_arer
comparted16338423comparted
compassed1645543compassed
compasses1547393compasses
compeer133811553comp__eer
compeller1546293compeller
compete134716553comp_ete_
competed154113593comp_eted
competes144117243comp_etes
compiler1438373comp_iler
complete143412053complete_
completed162810263completed
completers16298323completers
completes153212923completes
complexer22316203complexer
complier14310253comp_lier
complotted1743733complotted
compone136517193compo_ne_
comport133616843comport__
comports143411983comport_s
compos124818803compos___
composing16179843composing
compositely2053663compositely
compositors1754383compositors
composting17178053composting
composures1645133composures
compounder1743433compounder
compted143813523comp__ted
compute134513663comp_ute_
computed154110953comp_uted
computers15339753comp_uters
computes143914553comp_utes
concocter1247623concocter
contester11311183contester
cooter85128613co__o_ter
copastor1246343co_pastor
copter109822013co_p__ter
coster84331293c___oster
decomposer1753493decompos_er
dempster1355773demp_ster
dopester1137253do_pester
dumpster1344053dump_ster
hoopster1335543hoop_ster
importer12308913_importer
imposer113310103_impos_er
imposted13257403_imposted
imposters13347343_imposters
impostor12265483_impostor
opposer1135773_oppos_er
poster84129173___poster
rooster74415173ro__oster

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641927.76619140.0
3Display Results92920.0303066.7
 (SQL Overall)178691927.96922423.3
 
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.