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

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

101 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
collator1031037(None) 
collators11410341collators
chelator1347912chelator
collar83816172colla__r
collate92919682collat_e
collated113615062collated
collates103019142collates
collation11313992collation
collector1346392collector
collimator1494842collimator
fellator1176712fellator
ablator939843_ablator
adulator948593adulator
calculator1485423calculator
callaloo1044903callaloo
caveator1387233caveator
cellar84514983cella__r
cellarer10317923cellarer
chelators1448163chelators
citator9310123c_itator
clamor1049453c__lamor
coactor1139123co_actor
coater84329573co__ater
cockatoo16105783cockatoo
cocreator1346963cocreator
cocurator1347573cocurator
codebtor1343973codebtor
coeditor1145723coeditor
coenamor1244803coenamor
cofactor1545753cofactor
cogitator1245863cogitator
coleader1139183coleader
colessor1045233colessor
collage102813763colla_ge
collaged12279973collaged
collagen11338573collagen
collages113514243collages
collapse1244273collapse
collard103712923colla_rd
collards113310193collards
collared113211143collared
collaret103116703collaret
collars93816573colla_rs
collateral1244113collateral
collating12312763collating
collations12312853collations
collectors1446593collectors
colleger11227933colleger
collet84030363collet__
colleted113011663colleted
collets93517903collet_s
collider113410423collider
collier93618153coll_ier
collimators1594783collimators
collop107312313coll__op
colluder11276873colluder
color76123743co_l__or
colter84625093co_l_ter
combater1439383combater
compactor17256023compactor
contactor1348433contactor
copastor1246343copastor
coplanar1244473coplanar
copulatory1745753copulatory
correlator1245693correlator
coulter94115603coul_ter
creator93714443c_reator
cremator1269183cremator
curator9312213c_urator
deflator12328343deflator
delator83015023_delator
dilator82712783_dilator
dollar74110983dolla__r
donator8310263do_nator
emulator1048743emulator
epilator1049243epilator
fellators1247143fellators
idolator946243idolator
inflator1158033inflator
isolator847533isolator
locator93110423lo_cator
modulator1245793modulator
nonlabor1044843nonlabor
oblatory1345793_oblatory
orator6314533_o_rator
oscillator12133713oscillator
palliator1146003palliator
palpator1247123palpator
pollinator1244773pollinator
pollster1037103pollster
polluter1035403polluter
pulsator1085693pulsator
relator74016363_relator
rolltop944043roll_top
rotator7310833ro_tator
spoliator1144843spoliator
tolerator956753tolerator
vacillator1543493vacillator
valuator1196723valuator
violator1146283violator
zoolater1746093zoolater

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621017.48319532.5
3Display Results1011010.0333060.6
 (SQL Overall)1786911017.93922508.0
 
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.