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

58 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
complexer2231621(None) 
completer153310411completer
complexed23295981complexed
complexes22308101complexes
compeer133811552comp_e_er
compeller1546292compeller
complete143412052complete_
completed162810272completed
completers16298322completers
completes153212922completes
complex2037242complex__
complexest23265592complexest
complexly2543062complexly
complier14310252compl_ier
cameleer1246033camele_er
colleger11227933co_lleger
comelier12310653comel_ier
compacter17257883compacter
comparer143611363comp_arer
compeered1646303compeered
compeers143410013comp_e_ers
compelled1646133compelled
compellers1645193compellers
compere134616623comp_ere_
compered153414923comp_ered
comperes143217973comp_eres
compete134716553comp_ete_
competed154113593comp_eted
competes144117243comp_etes
compiler1438373comp_iler
complainer1645693complainer
compleat14710153comple_at
complect1659013comple_ct
complected19295863complected
complects1766413complects
complement18510103complement
completely1944553completely
completest16297873completest
complexify2952293complexify
complexing2444743complexing
complexion2343753complexion
complexity2653433complexity
complexness2453093complexness
complice1639333complice_
complices1739253complices
complied1539673compl_ied
compliers1538293compl_iers
complies14314523compl_ies
compline14313553compline_
complines15312833complines
composer145012953comp_oser
composter15369563composter
computer144511513comp_uter
coupler114713013coupl__er
diplexer1844213_diplexer
duplexer1842903_duplexer
perplexer2042753perplexer
simplexes2043993simplexes

Search took 9 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.530337152.8
2DLD Change Limit148641588.25318010.5
3Display Results58580.0301933.3
 (SQL Overall)178691588.81320275.8
 
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.