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

407 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
yirths1263953(None) 
airths95414251airths
births115713601births
firths125113501firths
girths105612271girths
mirths114912991mirths
yirth116513751yirth_
airth85621022airth_
airts55626342airt_s
berths114712422berths
birth105619872birth_
briths115113862briths
dirts66824462dirt_s
earths95014592earths
fifths15406542fifths
filths12389782filths
firth115819532firth_
friths124313582friths
garths104111502garths
girth95618842girth_
girts65423622girt_s
griths105211652griths
kiths125814972ki_ths
mirth106418892mirth_
ninths936932ninths
norths96812322norths
piths105817542pi_ths
sixths16416372sixths
tilths9459372tilths
virtus94310142virtus
widths1335122widths
worths127812892worths
yirds96612512yir_ds
yirrs8469192yir_rs
youths124510042youths
yurts87216532yurt_s
airbus848343airbus
airers64922313airers
airns55521033air_ns
airs46447423air__s
airt45757783airt__
airted74214503airted
airthed11328303airthed
aits46355533ai_t_s
aortas65417783aortas
arts49650263_art_s
azoths18366203azoths
baths105922923_baths
berth104917883berth_
bertha11429173bertha
berthas12398763berthas
beths105519223_beths
bights124417963bights
bimahs13508303bimahs
bints76130183bint_s
biotas84313923biotas
birch124914023birch_
birches143412323birches
birds85421333bir_ds
birks114920303bir_ks
birles84920643birles
birls74023163bir_ls
biros75325133bir_os
birrs74917103bir_rs
birses84717733birses
birthed13228593birthed
bites75641173bi_tes
bits66148163bi_t_s
bitts75022593bi_tts
booths115313793booths
borts76735453bort_s
brith104924373brith_
brits76433083brit_s
britts84813443britts
broths115013923broths
burghs12519923burghs
bypaths1743193bypaths
cartes86239473cartes
carts78946293cart_s
certes84623083certes
cheths14389823cheths
circus104310593circus
cires74932913cir_es
cirrus8349173cirrus
cists76624533cist_s
cistus84611343cistus
cites74435583ci_tes
citrus83610913citrus
cloths115512483cloths
couths115715393couths
crits75527573crit_s
crwths1433433crwths
darts67635733dart_s
dearths11498843dearths
deaths105914443deaths
depths12428573depths
diets66026643diet_s
dights114016963dights
dints67431313dint_s
dirams94413703dirams
dirges84915103dirges
dirks105619523dir_ks
dirls64720503dir_ls
dirt55550383dirt__
dirties83119383dirties
dirty95617803dirt_y
ditas65923673di_tas
dites66339153di_tes
dits56450523di_t_s
dittos74111973dittos
earth85023053earth_
earthy12399943earthy
eighths14388293eighths
eights103618983eights
eths76619523__eths
faiths124610273faiths
farts88336843fart_s
fiats85324483fiat_s
fifth145210923fifth_
fights133816553fights
filth115015823filth_
filthy15356423filthy
firers94922683firers
fires85740753fir_es
firms105217423fir_ms
firns86018543fir_ns
firs76637713fir__s
firsts95110923firsts
fists85527543fist_s
fits76043463fi_t_s
flirts95411483flirt_s
fortes95327183fortes
forth116222673forth_
fortis95418613fortis
forts86034453fort_s
fourths13374953fourths
frites94922483frites
frith115922033frith_
frits86129103frit_s
fritts94613193fritts
froths125411443froths
garth94720223garth_
gerahs1039413gerahs
gifts96214963gift_s
gilts64924263gilt_s
girds74816993gir_ds
girls64518393gir_ls
girns64516803gir_ns
girons75014373girons
giros65722653gir_os
girsh95310023girsh_
girshes11248293girshes
girt56646423girt__
girted83912873girted
girthed12266243girthed
gists66026193gist_s
gites65630183gi_tes
gits55744593gi_t_s
goths96513003_goths
grith95520373grith_
grits65529583grit_s
harts88441593hart_s
hearths135311073hearths
heaths126316383heaths
heths116317783_heths
hiatus938223hiatus
highs125412523hi_ghs
highths13358003highths
hights133716893hights
hijrahs2043443hijrahs
hilts86924413hilt_s
hints87330623hint_s
hirees95117293hirees
hirers94518063hirers
hires86134343hir_es
hists86328373hist_s
hits75545133hi_t_s
horahs126313873horahs
hurts86922823hurt_s
ichs96214713_i_chs
ictus7249693_ictus
intis55121643_intis
iotas54821113_iotas
ires45639283_ir_es
irids66417773_irids
iris45732553_ir_is
iritis63113733_iritis
irks86220133_ir_ks
irons55324133_irons
its35538833_i_t_s
jilts124717413jilt_s
karts97630113kart_s
kheths16495973kheths
kilts95122183kilt_s
kirks84915263kir_ks
kirns95315453kir_ns
kirs85831733kir__s
kirtle10309473kirtle
kirtles11309663kirtles
kists95822113kist_s
kites95432543ki_tes
kith115826353ki_th_
kithe125917453ki_the
kithes135016653ki_thes
kits86441763ki_t_s
kurtas10349883kurtas
laths86022403_laths
lichts113712383lichts
lifts85719063lift_s
lights104519913lights
lilts55822803lilt_s
lints57137193lint_s
liras56021983lir_as
liroth938383liroth_
lists56628693list_s
litas54923773li_tas
lithe84922013li_the
litho86513783li_tho
lithos94212553li_thos
litres65220393litres
lits46252493li_t_s
marts77442233mart_s
maths105624023_maths
meths105320233_meths
mights123516253mights
milts75430713milt_s
mints76834043mint_s
mires75640883mir_es
mirins83918903mirins
mirks115122143mir_ks
mirs66940573mir__s
mirzas1738173mirzas
mists76633903mist_s
mites75141803mi_tes
mitis75425993mi_tis
mitres83922073mitres
mitts75523753mi_tts
months113812933months
morphs13149433morphs
morts75533563mort_s
moths106021553_moths
mouths115214533mouths
musths11589483musths
myrrhs1443593myrrhs
myths135911603_myths
nerts55924983nert_s
nighs95013613ni_ghs
nights104117723nights
ninth8314583ninth_
nites55736343ni_tes
nitres65519333nitres
nitros64214123nitros
nits45741643ni_t_s
north86018273north_
oaths86117313_oaths
ortho8312293_ortho
orts46538333_ort_s
parts77743373part_s
paths105521383_paths
pietas84516503pietas
pintas85021393pintas
pintos86021293pintos
pints75936223pint_s
pirates93020323pirates
pirns76020093pir_ns
pistes85325633pistes
pitas77427673pi_tas
pith95432693pi_th_
pithy135614463pi_thy
pits66348743pi_t_s
pittas86014523pittas
plinths1236123plinths
ports75934593port_s
pyrites12812203pyrites
quirts154213553quirt_s
rebirths1343083rebirths
riatas63915083riatas
rictus8379193rictus
rifts85718643rift_s
rights104019333rights
riots54922013riot_s
rites54442553ri_tes
rouths95416823rouths
rowths12458173rowths
ruths85714643_ruths
shirts94918333shirt_s
sifts84918923sift_s
sighs95416743si_ghs
sights103818013sights
silts55330823silt_s
sinhs86719603si_nhs
sirees64624583sirees
sirens65318153sirens
sires55945373sir_es
sirrahs10377303sirrahs
sirras63814863sirras
sirs44338333sir__s
sirups83710533sirups
sites56045433si_tes
sith75435153si_th_
sits45050203si_t_s
situs55019233si_tus
sixtes133612403sixtes
sixth155512233sixth_
skirts104111503skirt_s
sloths94911883sloths
smiths114711023smiths
snaths95112913snaths
sooths95715583sooths
sorts54536663sort_s
soths86218623_soths
souths95216603souths
spilths12356023spilths
spirts85317133spirt_s
straths102711713straths
surahs94515543surahs
swarths13537323swarths
swaths125312643swaths
synths12377883synths
tarts57242023tart_s
tenths94412663tenths
teths85418513_teths
tights104015853tights
tilth85515363tilth_
tilts55325613tilt_s
tints56030923tint_s
tires55437493tir_es
tirls54519803tir_ls
tiros54524893tir_os
tithe85319703ti_the
tithes94720213ti_thes
titis56023813ti_tis
titres64718933titres
tits46145033ti_t_s
tooths96013803tooths
torahs95115643torahs
tortas64918253tortas
tortes64826053tortes
torts56138123tort_s
troths95414153troths
truths9449503truths
verts85724733vert_s
vertus94613603vertus
vireos94212453vireos
vires84529683vir_es
virgas1048883virgas
virls85618603vir_ls
virtu85314093virt_u
virtue9358673virtue
virtues10338023virtues
virus85316843vir_us
vistas94513273vistas
warmths1583783warmths
warts814840403wart_s
width12310963width_
wights133315783wights
wilts85023503wilt_s
wirers94617893wirers
wires86034913wir_es
wists86728523wist_s
wites85536963wi_tes
with105730473wi_th_
withe115220233wi_the
withes124620843wi_thes
withy144813763wi_thy
wits76044873wi_t_s
worth117120523worth_
worthy15598803worthy
worts88631183wort_s
wraths123810083wraths
writes94420333writes
writhe125310703writhe
writhes134811703writhes
writs86624383writ_s
yachts1437023yachts
yairds10448023yair_ds
yards95324613yar_ds
yarns85621793yar_ns
yeahs115214553y_eahs
yecchs16414953yecchs
yechs136112583y_echs
yentas94614213yentas
yentes95517603yentes
yerbas11119293yerbas
yerks125416563yer_ks
yetis85418393y_etis
yetts86715133y_etts
yids85224953yi__ds
yields10466843yields
yikes125117753yi_kes
yills83921553yi_lls
yins75335123yi__ns
yipes106017843yi_pes
yips95226693yi__ps
yird87018983yir__d
yirr76513573yir__r
yirred10426963yirred
yodhs12669013y_odhs
yoghs125410593y_oghs
yores85031323yor_es
youth115315043youth_
yurt76435043yurt__
yurta86014253yurt_a
zibeths2142933zibeths
zirams17438643zirams
zitis145815583zi_tis
zits136030293zi_t_s

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164075.37620966.5
3Display Results4074070.1233308.9
 (SQL Overall)1786914075.63931688.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.