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

120 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
tutu4842317(None) 
tut36758091tut_
tuts45838451tuts
tutus55214811tutus
auto47432082auto
bubu85022662bubu
but55963022but_
bute66739672bute
buts67247692buts
butt65143742butt
butut75522912butut
cut57957662cut_
cute66440452cute
cuts65841152cuts
cutup9410092cutup
duty85321452duty
fugu85419862fugu
futz167823802futz
guru54623912guru
gut46753852gut_
guts56637252guts
hut66457292hut_
huts76737442huts
juju103612122juju
juku154414852juku
jut105944012jut_
jute115327892jute
juts115930162juts
kudu95815422kudu
kuru85521802kuru
latu47934182latu
litu47631562litu
luau44824162luau
lulu44122882lulu
lute46341012lute
lutz136826322lutz
mumu86022062mumu
mut58357182mut_
mute65136872mute
muts64839982muts
mutt65739402mutt
nut36651962nut_
nuts45032672nuts
out38072152out_
outs45746962outs
pupu87620712pupu
put55759072put_
puts65641752puts
putt66937842putt
putz158326322putz
rut35560522rut_
ruth76825992ruth
ruts44541492ruts
sulu45128422sulu
tabu66328492tabu
tat37690292tat_
tate44748602tate
tats46858132tats
tau36856902t_au
taut47048962taut_
tauts56125512tauts
tet39274982tet_
teth76327882teth
tets45847452tets
thou76722212thou
thru76818942thru
tit36771042tit_
titi47130612titi
tits46145032tits
tofu76921332tofu
tolu45529152tolu
tot38884772tot_
tote46643672tote
tots46654122tots
tout46753822tout_
touts54830392touts
truth85214152truth
tub55640032tu_b
tuba65422362tuba
tube65828662tube
tubs65430062tubs
tuck104626572tuck
tufa75016612tufa
tuff104528522tuff
tuft76929512tuft
tufts85713272tufts
tufty114810412tufty
tug45937402tu_g
tugs56231672tugs
tui37034022tu_i
tuis44829642tuis
tule45735872tule
tump85927032tump
tun35845192tu_n
tuna45127842tuna
tune45635862tune
tung55328162tung
tuns45138662tuns
tup56037542tu_p
tups65628762tups
tuque14469192tuque
turd56027622turd
turf75334052turf
turk86125862turk
turn46330382turn
tush74523902tush
tusk85621632tusk
tutee5423522tutee
tutor5712492tutor
tutti54614672tutti
tutty85217022tutty
tutued7349412tutued
tux105426572tu_x
ulu36028702_ulu
ut28647032_ut_
uta37425582_uta
ute35335882_ute
uts35534372_uts
vatu76524332vatu
yutz167519882yutz

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.0762351197.4
2DLD Change Limit298721200.90632971.3
3Display Results1201200.0333636.4
 (SQL Overall)1786911201.015176050.2
 
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.