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

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

124 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
comparators178568(None) 
comparator1665801comparator_
compactors18256252compa_ctors
compradors1743782comp_radors
compurgators19102942compurgators
cooperators1547002cooperators
corporators1546652corporators
cocurators1447303co_curators
commutators1754433commutators
compacters18247033compa_cters
compactor17256023compa_ctor_
comparatist1756323comparatist
comparatists1853733comparatists
comparative20176213comparative
comparatives21164853comparatives
comparers15319393compar__ers
comparisons1753973comparisons
comparts144210833compar_t__s
compensators1854373compensators
competitors1753553competitors
compositors1754383compositors
comprador1643593comp_rador_
compradore1752743comp_radore
compradores1852603comp_radores
compurgator1882823compurgator_
conspirators1655533conspirators
cooperator1446833cooperator_
copastors1346993co_pa_stors
corporator1446943corporator_
imperators1447713_imperators
operators11410753_o_perators
preparators1554723preparators
separators1246503_separators
amputators1444224_amputators
apparitors1443014_apparitors
aspirators1247004_aspirators
calibrators1553964calibrators
capacitors1643594c_apacitors
castrators1247454c_astrators
celebrators1544414celebrators
chaparajos2451584chaparajo_s
coactors1239484co__a_ctors
cocreators1447154co_creators
cocurator1347574co_curator_
cofactors1645944co_fa_ctors
cogenerators1553984cogenerators
cogitators1346004co_gitators
collaborators17142074collaborators
collators11410344co__llators
collimators1594784collimators
comanagers1543834com_anagers
combaters1538114com__baters
combinatory2054024combinatory
combustors1643754com_bustors
comforters17275204comfor_ters
commemorators1862454commemorators
commentators1854794commentators
comminatory2055244comminatory
commutator1644674commutator_
compacter17257884compa_cter_
compactions1946544compactions
compacts16368904compa_ct__s
companions1697264compa_nions
comparable1845604compara_ble
comparably2154394compara_bly
comparativist2262554comparativist
comparer143611364compar__er_
compares143816434compar___es
comparison1644354compariso_n
compart134016004compar_t___
comparted16338424compar_t_ed
comparting17188384compar_ting
compassions1745774compassions
compatriots1753544compatriots
compensator1754674compensator_
compensatory2163644compensatory
competitor1653734competitor_
compilations1848684compilations
completers16298324comp_leters
comports143411984compor_t__s
compositor1644634compositor_
composters16388334comp_osters
compressors1754194compressors
compurgations20123894compurgations
computations1848124computations
computers15339754comp__uters
consecrators1656054consecrators
conservators1755974conservators
conspirator1555654conspirator_
contactors1448854conta_ctors
contractors1549164contractors
convertors1549134conver_tors
cooperates1469614cooperat_es
cooperations1659194cooperations
copartners1443574co_partners
copastor1246344co_pa_stor_
copulatory1745754co_pulatory
corporates14410734corporat_es
corporations16129484corporations
correlators1345604correlators
curators10311724c___urators
depurators1346484_depurators
dominators1397484dom_inators
emanators1147034_em_anators
evaporators1653484evaporators
impactors15265014_impa_ctors
imparters13276574_impar_ters
imperator1347784_imperator_
incorporators1763014incorporators
inspirators1345554inspirators
migrators1247544__migrators
moderators1386644mo_derators
nominators1277554nom_inators
numerators1245554num_erators
obturators1244304_obturators
operator10310094_o_perator_
orators7313824_o___rators
paradors113411904___paradors
preparator1445244preparator_
preparatory1853774preparatory
propagators1654224propagators
respirators1375444respirators
separator1146264_separator_
tolerators1046734to_lerators

Search took 10 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 Filter1786911488190.406440125.6
2DLD Change Limit1488191248.82616861.4
3Display Results1241240.0801550.0
 (SQL Overall)1786911249.31219189.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.