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

206 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
twos7671802(None) 
taos45541001taos
tows78545551tows
twas76824081twas
two67925831two_
wos66953531_wos
abos67734412abos
ados57633512ados
apos65433822apos
avos77227012avos
awes76037552awes
awls75926092awls
awns75324432awns
awol75620672awol
awols84713522awols
bios66335322bios
boos67955032boos
bos57966812_bos
bows96242862bows
bros65635662bros
coos67456492coos
cos510270392_cos
cows97046642cows
cwms11439572cwms
dos48062312_dos
dows85941052dows
duos56728132duos
egos55821652egos
epos66723732epos
eros45238452eros
ethos85514192ethos
ewes76328702ewes
goos57644912goos
gos47155132_gos
hos68364192_hos
hows106345602hows
iwis77117012iwis
jows146632092jows
kos76944822_kos
loos49051122loos
lows75843012lows
mhos95517772mhos
moos66051302moos
mos57067122_mos
mows96340832mows
naos47429732naos
nos38859322_nos
nows75738232nows
onos46229002onos
os211359882__os
ottos54714322ottos
owes75137102owes
owls76022932owls
owns76819582owns
poos65949112poos
pows95537662pows
pros65742782pros
rhos76319062rhos
rows75941752rows
sos37761602_sos
sows75342492sows
stows86622702stows
swob95218632swob
swobs104910892swobs
swop95120502swop
swops105913972swops
swot75134662swot
swots85518432swots
tabs66842982tabs
tacos77023552tacos
tads57143942tads
tags55545232tags
tams67247932tams
tans46154822tans
tao38358952tao_
taps66050672taps
taros55640822taros
tars46763952tars
tas38477102t_as
tass45640572tass
tats46858132tats
taus46342732taus
tavs75630972tavs
taws75641592taws
teas45851492teas
teds54932572teds
tees45353582tees
tegs56031492tegs
telos55424522telos
tels46841692tels
tens45647412tens
tets45847462tets
tews76431642tews
this76027382this
tho67433962tho_
those85218142those
thou76722212thou
thous86017262thous
thus76721472thus
tics65729632tics
ties45248312ties
tils45739612tils
tins45251302tins
tips66436762tips
tiros54524892tiros
tis37056642t_is
tits46145042tits
to218858982t_o_
tod49457072t_od
tods56141842tods
toe310166852t_oe
toes46956442toes
tog410255042t_og
togs57242432togs
tom514358052t_om
toms68343492toms
ton310265102t_on
tons46553052tons
too38965422t_oo
took86531072took
tool46735682tool
tools55325242tools
toom66532932toom
toon47740632toon
toons55027532toons
toot45958882toot
toots55331872toots
top510560682t_op
topos75726392topos
tops66248122tops
tor39261682t_or
toros54336192toros
tors46157382tors
tosh74826812t_osh
toss45637972toss
tost48351922t_ost
tot38884772t_ot
tots46654122tots
tow610557362t_ow
town76928702town
towns86018882towns
towy105325472towy
toy69655192t_oy
toyos87519142toyos
toys78036342toys
tres46542902tres
trios55528092trios
trod57627952trod
trog57628212trog
trogs67022602trogs
trois57226092trois
trop66833302trop
trot46351312trot
trots56629942trots
trow78031422trow
trows88826182trows
troy77429682troy
troys86418612troys
tsks86410662tsks
tubs65430062tubs
tugs56231672tugs
tuis44829642tuis
tuns45138662tuns
tups65628762tups
tuts45838452tuts
twa67721642tw_a
twae74719572twae
twaes86513662twaes
twat75831512twat
twats86616602twats
twee76827082twee
twig87615772twig
twigs96911172twigs
twin76023082twin
twins85118982twins
twist86820982twist
twit76329062twit
twits86015792twits
tyes76433372tyes
typos106015812typos
tyros85118592tyros
udos56619902udos
vows106626942vows
was68767562_was
wis66552332_wis
wo510447762_wo_
woe66651242_woe
woes76440662_woes
wog76242732_wog
wogs86531402_wogs
wok106334172_wok
woks116224902_woks
won66252062_won
wons74942042_wons
woo66949802_woo
woos76238802woos
wop87145132_wop
wops96634152_wops
wost76544362_wost
wot610467482_wot
wots76342892_wots
wow96643472_wow
wows104633492_wows
yows106433122yows
ywis105313102ywis
zoos135828802zoos

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.283631417.0
2DLD Change Limit298722060.89033564.0
3Display Results2062060.0464478.3
 (SQL Overall)1786912061.219146588.2
 
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.