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

86 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
completer15331041(None) 
complete143412051complete_
completed162810271completed
completers16298321completers
completes153212921completes
complexer22316211complexer
compacter17257882compacter
compeer133811552comp_e_er
compeller1546292compeller
compete134716552comp_ete_
competed154113592comp_eted
competes144117242comp_etes
complected19295862complected
completely1944552completely
completest16297872completest
complexed23295982complexed
complexes22308112complexes
complier14310252compl_ier
composter15369562composter
computer144511512comp_uter
cameleer1246033camele_er
chapleted1743973chapleted
colleger11227933co_lleger
colleted113011663co_lleted
colter84625093co__l_ter
combater1439383com_bater
comelier12310653comel_ier
comether1537253com__ether
comforter16255983comforter
commenter151410693commenter
commuter143010153com_muter
compacted18297363compacted
compacters18247023compacters
compactor17256023compactor
comparer143611363comp_arer
comparted16338423comparted
compeered1646303compeered
compeers143410013comp_e_ers
compelled1646133compelled
compellers1645193compellers
compere134616623comp_ere_
compered153414923comp_ered
comperes143217973comp_eres
competent15411253comp_etent
compiler1438373comp_iler
complainer1645693complainer
compleat14710153comple_at
complect1659013comple_ct
complects1766413complects
complement18510103complement
completing1748423completing
completion1647303completion
completive1946233completive
complex2037243compl__ex
complexest23265593complexest
complexly2543073complexly
complice1639333complice_
complices1739253complices
complied1539673compl_ied
compliers1538293compl_iers
complies14314523compl_ies
compline14313553compline_
complines15312833complines
complot13310683complot__
complots1438163complot_s
complotted1743733complotted
comported16319533comported
composer145012953comp_oser
composted16378813composted
composters16388323composters
compote135616463comp_ote_
compotes144716513comp_otes
compted143813523comp__ted
compute134513663comp_ute_
computed154110953comp_uted
computers15339753comp_uters
computes143914553comp_utes
copter109822013co_p__ter
coulter94115603co_ul_ter
coupler114713013coupl__er
couplet114717943couplet__
couplets12389873couplet_s
coveter122912063co__veter
depleter11298863_depleter
incomplete1664263incomplete_
uncompleted1853993uncompleted

Search took 7 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.423422437.4
2DLD Change Limit148641866.26623721.8
3Display Results86860.0461869.6
 (SQL Overall)178691866.73526531.7
 
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.