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

280 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
this7602738(None) 
ahis76135381ahis
chis95933311chis
ghis85020161ghis
his66359501_his
khis117017981khis
phis95724901phis
thin76732391thin
thins85826331thins
thio77225411thio
thir76420541thir
thus76721471thus
tis37056641t_is
tuis44829641tuis
ahi68040232ahi_
ahs68644822ah_s
ais39083572_ais
amis66445322amis
anis45746462anis
aphis105917132aphis
axis116127912axis
bis56860662_bis
bris65539612bris
chais107530312chais
chi86228652chi_
chia96026622chia
chias104625522chias
chic115925202chic
chics123920942chics
chid106626402chid
chin96934742chin
chins105631462chins
chip116726422chip
chips125721252chips
chit96937462chit
chits105424572chits
cis57748032_cis
cris66233432cris
dais57040702dais
dis46459892_dis
egis56520652egis
ethic101511222ethic
ethics11169282ethics
ethos85514192ethos
eths76619522eth_s
etuis54013132etuis
ghi77019882ghi_
has67372652_has
hes66654202_hes
hi57947582_hi_
hic86540562_hic
hid76248382_hid
hie67652702_hie
hies74842832_hies
him86247662_him
hims95230972_hims
hin67559562_hin
hins76447992_hins
hip86750432_hip
hips96433702_hips
hisn79620932_hisn
hiss75629212_hiss
hist76551542_hist
hit66569192_hit
hits75545132_hits
hos68364192_hos
ibis66519582ibis
iris45732552iris
is27048212__is
iwis77117012iwis
khi106318302khi_
kis78051482_kis
kois85129402kois
kris86423602kris
lathis95516172lathis
leis45739602leis
lis37162272_lis
mhos95517772mhos
mis58162622_mis
obis66226842obis
ohia75719362ohia
ohias84415572ohias
ohms95514032ohms
ohs66232312oh_s
phi86524202phi_
phiz186718842phiz
pis56362032_pis
pois66539042pois
psis68120342psis
qis126934382_qis
rais45252622rais
reis45343232reis
rhos76319062rhos
rhus75114052rhus
seis45542392seis
shes75734352shes
shies86136552shies
shim95827862shim
shims104422552shims
shin75634312shin
shins85131042shins
ship95228242ship
ships105123772ships
shist84829612shist
shit76745942shit
shits84731172shits
shiv105721172shiv
shivs115018802shivs
shris84221452shris
sis37360542_sis
skis84825292skis
sris45434152sris
tabs66842982tabs
tads57143942tads
tags55545232tags
tahrs85412332tahrs
tail45443652tail
tails55634192tails
tain45548072tain
tains54936322tains
tamis76728732tamis
tams67247932tams
tans46154822tans
taos45541002taos
tapis75028862tapis
taps66050672taps
tars46763952tars
tas38477102t_as
tass45640572tass
tats46858132tats
taus46342732taus
tavs75630972tavs
taws75641592taws
taxis126821972taxis
teas45851492teas
teds54932572teds
tees45353582tees
tegs56031492tegs
tels46841692tels
tens45647412tens
tets45847462tets
tews76431642tews
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
thaws116515462thaws
the67436052th_e
thee78039062thee
thein85919022thein
theins95015422theins
their85512152their
theirs94610352theirs
theism1139482theism
theist9314762theist
them97427042them
then78429692then
thens85921832thens
these86519012these
thesis94913732thesis
thesp105410312thesp
thew108226232thew
thews117416192thews
they107223752they
thick145613352thick
thicks154511992thicks
thief114516302thief
thigh12410122thigh
thighs1346632thighs
thill85918732thill
thills95515382thills
thine85026862thine
thing96622982thing
things104914302things
think125018802think
thinks134613362thinks
thiol87616042thiol
thiols95112762thiols
third95912492third
thirds10438602thirds
thirl85416822thirl
thirls95012062thirls
thirst9312252thirst
tho67433962th_o
those85218142those
thou76722212thou
thous86017262thous
thrip103012182thrip
thrips11299012thrips
thro77726422thro
thru76818942thru
thud85613912thud
thuds95110132thuds
thug86415482thug
thugs95611992thugs
thy97022912th_y
ti28448292t_i_
tic56343462t_ic
tics65729632tics
tie36557532t_ie
ties45248312ties
tikis95615972tikis
til36350262t_il
tils45739612tils
tin36362172t_in
tins45251302tins
tip56551222t_ip
tipis76019922tipis
tips66436762tips
tit36771052t_it
titis56023812titis
tits46145042tits
tods56141842tods
toes46956442toes
togs57242432togs
toil46536282toil
toils54527492toils
toit46353062toit
toits55327472toits
toms68343492toms
tons46553052tons
topis76025832topis
tops66248122tops
tors46157382tors
toss45637972toss
tots46654122tots
tows78545552tows
toys78036342toys
tres46542902tres
tries55742812tries
trig55528162trig
trigs65423062trigs
trim65329522trim
trims75021472trims
trio45233342trio
trios55528092trios
trip66830392trip
trips74923362trips
trois57226092trois
tsks86410662tsks
tubs65430062tubs
tugs56231672tugs
tui37034022tui_
tuns45138662tuns
tups65628762tups
tuts45838452tuts
twas76824082twas
twig87615772twig
twigs96911172twigs
twin76023082twin
twins85118982twins
twist86820982twist
twit76329062twit
twits86015792twits
twos76718022twos
tyes76433372tyes
tyin76424002tyin
vis66747612_vis
whid115418872whid
whids125413982whids
whig115516422whig
whigs125612642whigs
whim126220532whim
whims134515332whims
whin105225692whin
whins114922332whins
whip125521842whip
whips134917082whips
whir105519282whir
whirs115218092whirs
whish144512922whish
whisk154510142whisk
whist115322952whist
whit104834172whit
whits115923822whits
whiz195919942whiz
whys137011662whys
wis66552332_wis
xis106935332_xis
ywis105313102ywis

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.313570897.8
2DLD Change Limit298722800.90632971.3
3Display Results2802800.0634444.4
 (SQL Overall)1786912801.282139384.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.