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

158 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
citator931012(None) 
citators10310251citators
citatory1347211citatory
agitator946712agitator
citation10314362citation
cogitator1245862cogitator
creator93714442creator
curator9312212curator
dictator1147262dictator
dilator82712782dilator
imitator1047112imitator
nitrator849552nitrator
rotator7310832rotator
stator64015482_stator
titrator858542titrator
viator93211832vi_ator
vitiator1147042vitiator
abator84512713_abator
ablator939843ablator
activator1446443activator
actuator1046643actuator
aerator7314843aerator
agitato856573agitato_
agitators1046623agitators
animator101410293animator
aviator10229663aviator
avigator12236773avigator
bettor83612223bet_tor
bitter84622673bit_ter
cantor85621523c_antor
captor104914603c_aptor
castor84418533c_astor
castrator1147643castrator
catalo8314853catalo_
catalog1038003catalog
catalos9414163catalos
cater74840723c__ater
caveator1387233caveator
chador1238673c_hador
chantor123710313chantor
chatter124416643chatter
cheater124816963cheater
chelator1347913chelator
chitter124112963chit_ter
ciao64924183ci_a_o_
cigar8911803ciga__r
cilantro1042673cilantro
citable11313463citable
citadel1044383citadel
citations11312503citations
citer74827333ci__ter
cither114616683cit_her
citrate92216803citrat_e
citrated112712253citrated
citrates102315093citrates
citron83112983cit_ron
cittern9339143cit_tern
clamor1049453c_lamor
clatter94014973clatter
coactor1139123coactor
coater84329573c_oater
cofactor1545753cofactor
cogitators1346003cogitators
collator10310373collator
contactor1348433contactor
copastor1246343copastor
cottar84613813cot_tar
cotter84926673cot_ter
cotton8312993cot_ton
crater85026643c_rater
craton84517193c_raton
creators102814413creators
cremator1269183cremator
critter94113033crit_ter
crittur9315133crit_tur
cuatro838433c_uatro
cunctator1343923cunctator
curators10311723curators
cutter84521003cut_ter
cutwater1344833cutwater
cytaster1383863cytaster
decimator1447733decimator
delator83015023delator
diatom939453di_atom
dictators1247363dictators
dilatator1044143dilatator
dilater83515653dilater
dilators93213193dilators
dilatory12279273dilatory
dilutor8256013dilutor
ditto65315603dit_to_
dittos74111973dit_tos
donator8310263donator
epilator1049243epilator
equator1637483equator
excitatory2254343excitatory
fitter94120033fit_ter
gator64416033__gator
gigaton946343gigaton
gitano738043gitano_
gitanos837173gitanos
gyrator1135713gyrator
hesitator1286023hesitator
hitter94419863hit_ter
imitators1147013imitators
initiator998113initiator
irater65218353_irater
irritator945223irritator
jitter133314993jit_ter
legator83011133legator
levator10298963levator
levitator1245493levitator
lictor83610853li_ctor
literator948683literator
litigator1045503litigator
litter64324853lit_ter
locator93110423locator
matador1066253matador
meditator1246593meditator
migrator1147873migrator
minatory1338553minatory
mirador1046503mirador
mistutor1044943mistutor
mitigator1245413mitigator
natatory1146603natatory
negator83010673negator
nitrators949213nitrators
orator6314533_orator
picador1245923picador
piscator1246923piscator
potato8513433potato_
potatory1348413potatory
quittor16285603quit_tor
relator74016363relator
ritter63822423rit_ter
rotators8310203rotators
rotatory1147213rotatory
senator7313073senator
sitar54820543sita__r
sitter63323383sit_ter
stater64427563_stater
stators73915583_stators
tabor75518393__tabor
tatar56122063__tatar
tater54138613__tater
testator847373testator
titrators948383titrators
titter63421163tit_ter
tutor5712493__tutor
urinator847843urinator
viators102712023vi_ators
vibrator13227343vibrator
victor113210673vi_ctor
violator1146283violator
visitor1046203visitor
vitamer1235473vitamer
vitiators1246923vitiators
wittol935923wit_tol

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271586.76319817.7
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.23224708.4
 
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.