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

95 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
collators1141034(None) 
collator10310371collator_
chelators1448172chelators
collars93816572colla__rs
collates103019142collat_es
collations12312852collations
collectors1446592collectors
collimators1594782collimators
fellators1247142fellators
ablators1069883_ablators
adulators1048063adulators
calculators1574783calculators
callaloos1144223callaloos
caveators1497263caveators
cellarers11236503cellarers
cellars93713693cella__rs
chelator1347923chelator_
citators10310253c_itators
clamors11710093c__lamors
coactors1239483co_actors
coaters93525793co__aters
cobaltous1343563cobaltous
cockatoos17124443cockatoos
cocreators1447143cocreators
cocurators1447303cocurators
codebtors1444403codebtors
coeditors1245803coeditors
coenamors1344703coenamors
cofactors1645943cofactors
cogitators1346003cogitators
coleaders1237823coleaders
colessors1145663colessors
collagens12256043collagens
collages113514243colla_ges
collapses1344683collapses
collar83816173colla__r_
collard103712923colla__rd
collards113310193colla_rds
collarets11327333collarets
collate92919683collat__e
collated113615063collat_ed
collateral1244113collateral
collaterals1353383collaterals
collating12312783collating
collation11313993collation
collector1346393collector_
collegers12256843collegers
collets93517903collet__s
colliders12298073colliders
colliers103613583coll_iers
collimator1494843collimator_
collops112611753coll__ops
colluders12285613colluders
colors86622373co_l__ors
colters93522443co_l_ters
combaters1538113combaters
compactors18256253compactors
contactors1448853contactors
copastors1346993copastors
copulatory1745753copulatory
correlators1345593correlators
coulters103614313coul_ters
creators102814413c_reators
cremators1369823cremators
curators10311723c_urators
deflators13348153deflators
delators92314833_delators
dilators93213203_dilators
dollars83311023dolla__rs
donators9310403do_nators
emulators1148183emulators
epilators1149433epilators
fellator1176713fellator_
idolators1046283idolators
inflators1257713inflators
isolators947513isolators
locators102910433lo_cators
modulators1345333modulators
oblatory1345803_oblatory
orators7313823_o_rators
oscillators13113643oscillators
palliators1245823palliators
palpators1346803palpators
pollinators1354543pollinators
pollsters1137173pollsters
polluters1135033polluters
pulsators1175373pulsators
relators83316133_relators
rotators8310203ro_tators
spoliators1244823spoliators
tolerators1046733tolerators
vacillators1653333vacillators
valuators1286473valuators
violators1246583violators
zoolaters1844983zoolaters

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.420425454.8
2DLD Change Limit148641956.45623023.7
3Display Results95950.0432209.3
 (SQL Overall)178691956.91925826.1
 
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.