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

114 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
tutus5521481(None) 
tuts45838451tut_s
tutu48423171tutu_
autos56523322autos
bubus95115452bubus
butes714535872butes
buts67247692but_s
butts75824252butts
butut75522912butut
bututs8409422bututs
cultus85110732cultus
cutes79438312cutes
cutis77723752cutis
cuts65841152cut_s
cutup9410092cutup
cutups1036812cutups
dufus94010812dufus
fetus85816542fetus
fucus105515892fucus
fugus95914012fugus
gurus64318192gurus
guts56637252gut_s
humus106215072humus
huts76737442hut_s
ictus7249692ictus
jujus11347462jujus
jukus16398672jukus
jutes125125132jutes
juts115930162jut_s
kudus104910802kudus
kurus98015632kurus
lotus55718062lotus
luaus54514902luaus
lulus54315162lulus
lupus74512522lupus
lusus54813872lusus
lutes55836662lutes
mucus94015742mucus
mumus95517282mumus
mutes75033782mutes
muts64839982mut_s
mutts75120252mutts
nuts45032672nut_s
outs45746962out_s
pupus94614042pupus
puts65641752put_s
putts75719272putts
rubus76415052rubus
ruths85714642ruths
ruts44541492rut_s
situs55019232situs
status65515212status
sulus54821882sulus
tabus74820922tabus
talus55423262talus
tates55444982tates
tats46858132tat_s
taus46342732t_aus
tauts56125512taut_s
taxus125512482taxus
teths85418512teths
tets45847452tet_s
thous86017252thous
thus76721472t_hus
titis56023812titis
tits46145032tit_s
tofus86415422tofus
tolus55024482tolus
tonus56324302tonus
torus54329762torus
totes55139682totes
tots46654122tot_s
touts54830392tout_s
truths9449502truths
tubas75119572tubas
tubes74826452tubes
tubs65430062tu_bs
tucks114721122tucks
tufas85314382tufas
tuffs115118262tuffs
tufts85713272tufts
tugs56231672tu_gs
tuis44829642tu_is
tules54532792tules
tumps95420792tumps
tunas54224122tunas
tunes55332192tunes
tungs65520622tungs
tuns45138662tu_ns
tups65628762tu_ps
tuque14469192tuque
tuques15358372tuques
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623232turns
turps74918732turps
tusks94915532tusks
tut36758092tut__
tutee5423522tutee
tutees6514552tutees
tutor5712492tutor
tutors6912322tutors
tutti54614672tutti
tuttis63611372tuttis
tutty85217022tutty
tutued7349412tutued
tuxes124316042tuxes
ulus45622562_ulus
urus46426132_urus
utas45924952_utas
utes45930882_utes
uts35534372_ut_s
vatus86114642vatus

Search took 4 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 Filter178691538000.1731032896.0
2DLD Change Limit538001143.14017133.8
3Display Results1141140.0761500.0
 (SQL Overall)1786911143.38952726.8
 
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.