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

156 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
citators1031025(None) 
citator9310121citator_
citatory1347211citatory
agitators1046622agitators
citations11312502citations
cogitators1346002cogitators
creators102814412creators
curators10311722curators
dictators1247362dictators
dilators93213192dilators
imitators1147012imitators
nitrators949212nitrators
rotators8310202rotators
stators73915582_stators
titrators948382titrators
viators102712022vi_ators
vitiators1246922vitiators
abators94413083_abators
ablators1069873ablators
activators1545943activators
actuators1146443actuators
aerators8315613aerators
agitator946713agitator_
animators111210423animators
aviators11169903aviators
avigators13177093avigators
bettors93312473bet_tors
bitters94920363bit_ters
cantors94620753c_antors
captors113914983c_aptors
castors94919443c_astors
castrators1247443castrators
cataloes10311653cataloes
catalogs1148033catalogs
catalos9414163catalo_s
caters85336503c__aters
caveators1497263caveators
chadors1338753c_hadors
chantors133710263chantors
chatters134213953chatters
cheaters133613513cheaters
chelators1448163chelators
chitters133711173chit_ters
cigars9910723ciga__rs
cilantros1142603cilantros
citadels1142843citadels
citation10314363citation
citers85022983ci__ters
cithers124315773cit_hers
citrates102315093citrat_es
citreous1056853citreous
citrons92913223cit_rons
citrous93112993cit_rous
cittern9339143cit_tern
citterns10318123cit_terns
clamors11710093c_lamors
clatters103313913clatters
coactors1239473coactors
coaters93525793c_oaters
cofactors1645933cofactors
cogitator1245863cogitator_
collators11410343collators
contactors1448843contactors
copastors1346993copastors
cottars94412243cot_tars
cotters94323443cot_ters
cottons9312193cot_tons
craters95021893c_raters
cratons94316033c_ratons
creator93714443creator_
cremators1369813cremators
critters103511323crit_ters
critturs10374593crit_turs
cuatros938273c_uatros
cunctators1443723cunctators
curator9312213curator_
cutters94218963cut_ters
cutwaters1443613cutwaters
cytasters1483663cytasters
decimators1547503decimators
delators92314823delators
diatoms1039073di_atoms
dictator1147263dictator_
dilatators1144013dilatators
dilaters92513063dilaters
dilator82712783dilator_
dilatory12279273dilatory
dilutors9306653dilutors
dittos74111973dit_to_s
donators9310403donators
epilators1149433epilators
equators1737473equators
excitatory2254343excitatory
fitters104517753fit_ters
gators74115833__gators
gigatons1046053gigatons
gitanos837173gitano_s
gyrators1245993gyrators
hesitators1385853hesitators
hitters104717593hit_ters
imitator1047113imitator_
initiators10127313initiators
irritators1045133irritators
jitters144314473jit_ters
legators92811033legators
levators11249283levators
levitators1345403levitators
lictors93212593li_ctors
literators1048103literators
litigators1145383litigators
litters73422573lit_ters
locators102910433locators
matadors1156983matadors
meditators1346263meditators
migrators1247543migrators
minatory1338553minatory
miradors1146853miradors
mistutors1144763mistutors
mitigators1345373mitigators
natatory1146603natatory
negators92411173negators
nitrator849553nitrator_
orators7313823_orators
picadors1345853picadors
piscators1347083piscators
potatoes1039943potatoes
potatory1348413potatory
quittors17155413quit_tors
relators83316123relators
ritters74020623rit_ters
rotator7310833rotator_
rotatores946473rotatores
rotatory1147213rotatory
senators8312953senators
sitars65417593sita__rs
sitters74221553sit_ters
staters73922343_staters
stator64015483_stator_
tabors84517113__tabors
tatars64619793__tatars
taters64932203__taters
testators947333testators
titanous846553titanous
titrator858543titrator_
titters74219623tit_ters
tutors6912333__tutors
urinators947633urinators
viator93211833vi_ator_
viatores11257683vi_atores
vibrators14237253vibrators
victors123311183vi_ctors
violators1246583violators
visitors1146433visitors
vitamers1334683vitamers
vitiator1147043vitiator_
wittols1035733wit_tols

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 Filter1786911461620.500357382.0
2DLD Change Limit1461621567.53019410.6
3Display Results1561560.0632476.2
 (SQL Overall)1786911568.09322079.7
 
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.