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

113 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
equator163748(None) 
equators1737471equators
educator1147152educator
eductor1035862eductor
emulator1048742emulator
equate152012462equat_e
equated171910402equated
equates162012322equates
equation17310482equation
squalor1644422squalor
abator84512733_abator
ablator939863ablator
actuator1046643actuator
adulator948593adulator
aerator7314853aerator
aquatic1838113aquatic
aquatone1744913aquatone
aviator10229683aviator
citator9310123citator
creator93714453creator
cuatro838433_cuatro
curator9312213curator
deflator12328343deflator
delator83015033delator
depurator1247023depurator
deviator1248333deviator
dilator82712793dilator
donator8310263donator
eater54639843e__ater
editor738663e_ditor
educators1246993educators
educatory1545443educatory
eductors1135983eductors
ejector16378603ejector
elater64724203e_later
elector93313263elector
elevator1146723elevator
eluate62315433eluat_e
eluates72014683eluates
emanator1047293emanator
emulators1148183emulators
enactor938043enactor
enamor838753e_namor
epilator1049243epilator
equable1849253equable
equably2136183equably
equal1449823equa__l
equaled17166923equaled
equally1936873equally
equals1538703equa_ls
equating18310113equating
equations1839493equations
equatorial1954203equatorial
equinox2343013equinox
equites162212493equites
equity1838103equit_y
erector93513813erector
evacuator14114933evacuator
evaluator12104963evaluator
evertor1038723evertor
evictor12346373evictor
evocator1346573evocator
exactor1636633exactor
excitor1645993excitor
exequatur2551543exequatur
expiator1747043expiator
fellator1176723fellator
gator64416043__gator
gyrator1135723gyrator
laudator945883laudator
legator83011133legator
levator10298973levator
locator93110423locator
mediator1139053mediator
negator83010673negator
orator6314533_orator
peculator1387863peculator
quaestor1743313_quaestor
quahog1944103_quahog
quaker193811623_quaker
quarter163211863_quarter
quarto153511123_quarto_
quartos16328743_quartos
quasar1536843_quasar
quate144521413_quat_e
quatorze2642953_quatorze
quatre153512363_quatre
quaver18309313_quaver
questor16146633_questor
quittor16285603_quittor
quoter153510093_quoter
reductor1156433reductor
regulator1046973regulator
relator74016383relator
requestor1853023requestor
requiter17168643requiter
rotator7310833rotator
senator7313073senator
sequitur1742973sequitur
squalors1744583squalors
squarer163410663squarer
squat143720143squat__
squatly1946433squatly
squats153712963squat_s
squatter1735913squatter
squatty1964823squatty
stator64015483_stator
suitor63311053_suitor
testator847373testator
trustor7238413trustor
tutor5712493_tu_tor
valuator1196733valuator
viator93211843_viator

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 Filter1786911340270.626285448.9
2DLD Change Limit1340271137.81317154.4
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.48521059.6
 
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.