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

105 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
crittur931513(None) 
critter94113031critter
critturs10374591critturs
chitter124112962chitter
critters103511312critters
fritter103912772fritter
gritter83913352gritter
ritter63822412_ritter
bitter84622673_bitter
britt75732233britt__
brittle9168603brittle
brittler10165983brittler
brittly12165973brittly
britts84813443britt_s
ceinture1036313ceinture
centaur935783centaur
chatter124416643chatter
chitters133711163chitters
chitty14329433chitt_y
cistus84611343c_istus
citator9310113c_itator
citer74827323c_i_ter
cither114616683c_ither
citrus83610913c_itrus
cittern9339133c_ittern
clatter94014973clatter
clutter94211653clutter
cointer93616723cointer
coitus8511893coi_tus
contour939963contour
cottar84613813c_ottar
cotter84926673c_otter
crafter124111333crafter
crater85026633cr_ater
creator93714433creator
creature1038723creature
cribber13367663cribber
crier74724463cri__er
crimmer133310773crimmer
crimper136510423crimper
cringer103514243cringer
crinum1039333cri_num
crisper113511053crisper
crissum1144843crissum
crista8311803crist_a
cristae9310603cristae
crit65743713cri_t__
critic103616813cri_tic
critics112811093critics
critique1943033critique
crits75527573cri_t_s
crofter12299573crofter
cuittle946403cuittle
cutter84520993c_utter
drifter11348703drifter
emitter93211083emitter
faitour1034883faitour
fitter94120033_fitter
flitter103413903flitter
fractur12135563fractur
fraktur14153033fraktur
fretter103412753fretter
friseur1033673friseur
fritt86129413fritt__
fritted113611333fritted
fritters113810783fritters
fritts94613193fritt_s
frotteur1142503frotteur
glitter84211803glitter
grifter113810493grifter
grister83915413grister
gritted94110903gritted
gritters94210633gritters
grittier9316263grittier
gritty10338403gritt_y
hitter94419863_hitter
jitter133314993_jitter
knitter11348133knitter
litter64324853_litter
omitter9298503omitter
printer93917303printer
quitter162910753quitter
quittor16285603quittor
ratter64326313_ratter
rictus8379193_rictus
rigour7258023_rigour
rioter64817283_rioter
ritters74020613_ritters
rotter64325463_rotter
scripter12137773scripter
scripture1343873scripture
sitter63323383_sitter
skitter113810393skitter
slitter73615873slitter
spitter94015183spitter
titter63421163_titter
tittup834203_tittup
triter65120593tri_ter
tritium969013tritium
trotter73312253trotter
twitter10278093twitter
whitter139110893whitter
writer94416513wri_ter
writher134010853writher
written10336343written

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.1701051123.5
2DLD Change Limit1340271058.11016526.1
3Display Results1051050.0333181.8
 (SQL Overall)1786911058.31321495.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.