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

(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
titi4713061(None) 
tiki87620841tiki
tipi69924431tipi
tit36771041tit_
titis56023811titis
tits46145031tits
ziti136022371ziti
ait38093902ait_
aits46355532aits
anti45536362anti
bidi78226572bidi
bit57070902bit_
bite66547002bite
bits66148162bits
bitt65545812bitt
cite65640342cite
city95122622city
dit47071332dit_
dita56032522dita
dite55547552dite
dits56450522dits
ditz146929512ditz
fit66365452fit_
fits76043462fits
git46266052git_
gite55438612gite
gits55744592gits
hili75626632hili
hit66569192hit_
hits75545132hits
inti46626082inti
it28455682_it_
its35538832_its
kit78559872kit_
kite85338232kite
kith115826352kith
kits86441762kits
kiwi113211792kiwi
lati46438272lati
liri45128252liri
lit39377312lit_
litai55216362litai
lite47054542lite
lits46252492lits
litu47631562litu
loti46431832loti
midi75628472midi
mini65634552mini
miri66730372miri
mite66249412mite
mitis75425992mitis
mitt66145492mitt
mity95528212mity
nidi56524392nidi
nisi45823242nisi
nit37065942nit_
nite45943582nite
nitid61817832nitid
nits45741642nits
otitic83112682otitic
otitis63612342otitis
piki106520562piki
pili66130352pili
pit56471922pit_
pita65436432pita
pith95432692pith
pits66348742pits
pity96031932pity
rite45849452rite
ritz135129982ritz
roti46332922roti
sati45539322sati
sit35877752sit_
site47052412site
sith75435152sith
sits45050202sits
tali46837162tali
tat37690292tat_
tate44748602tate
tats46858132tats
taxi117124762taxi
tet39274982tet_
teth76327882teth
tetri52716452tetri
tets45847452tets
ti28448292__ti
tibia7312402tibia
tic56343462ti_c
tick106231222tick
tics65729632tics
tide55237372tide
tidy86822412tidy
tie36557532ti_e
tied55535212tied
tier44936142tier
ties45248312ties
tiff104727722tiff
tike85534482tike
tikis95615972tikis
til36350262ti_l
tile45451442tile
till45941202till
tils45739612tils
tilt46252422tilt
tilth85515362tilth
tilts55325612tilts
time66235012time
timid84815722timid
tin36362172ti_n
tine45855132tine
ting56139892ting
tins45251302tins
tint46758862tint
tints56030922tints
tiny76134632tiny
tip56551222ti_p
tipis76019922tipis
tips66436762tips
tire46143352tire
tirl45029922tirl
tiro46832362tiro
tis37056642ti_s
titan53318172titan
titbit839822titbit
titer55430612titer
tithe85319702tithe
titian62512662titian
title54721072title
titre54619392titre
tittie63213152tittie
titty85316652titty
tivy1014516862tivy
toit46353062toit_
toits55327472toits
topi67830392topi
tori47542152tori
tot38884772tot_
tote46643672tote
tots46654122tots
trite54730032trite
tui37034022t_ui
tut36758092tut_
tuts45838452tuts
tutti54614672tutti
tutu48423172tutu
twit76329062twit_
twits86015792twits
vita75828522vita
wit66563772wit_
wite75443272wite
with105730472with
wits76044872wits
yeti75823212yeti
zit126049992zit_
zitis145815582zitis
zits136030292zits

Search took 2 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 Filter178691298720.0802233637.5
2DLD Change Limit298721561.01329488.6
3Display Results1561560.0632476.2
 (SQL Overall)1786911561.156154577.0
 
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.