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

272 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
toits5532747(None) 
doits66223671doits
tits46145031t_its
tofts84919241tofts
toils54527491toils
toit46353061toit_
toots55331871toots
torts56138121torts
tots46654121to_ts
touts54830391touts
twits86015791twits
adits66523712adits
aits46355532_aits
baits76630582baits
bits66148162_bits
boats75635152boats
boils75427192boils
boite74426322boite
boites84322702boites
bolts76232112bolts
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
brits76433082brits
chits105424572chits
coats75634992coats
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
coitus8511892coitus
colts76633292colts
coots75636842coots
costs77231142costs
cots68054842co_ts
crits75527572crits
dits56450522_dits
doats65224882doats
doit56347852doit_
dolts65626312dolts
dots55647662do_ts
droits74314312droits
duits65021882duits
edits65819032edits
emits75421472emits
exits125515912exits
fits76043462_fits
flits85625222flits
foils85025812foils
foins85523382foins
foist85730972foist
foists95413982foists
fonts86124752fonts
foots85528282foots
forts86034452forts
frits86129102frits
gaits65726012gaits
gits55744592_gits
goats65527302goats
gouts64826172gouts
grits65529582grits
hits75545132_hits
hoist86433212hoist
hoists95516022hoists
holts85627912holts
hoots84830242hoots
hosts85526702hosts
hots78349322ho_ts
its35538832__its
joins125818412joins
joints133811452joints
joist125125652joist
joists134711032joists
jolts125018882jolts
jots116336142jo_ts
kits86441762_kits
knits93914742knits
kois85129392koi_s
lits46252492_lits
lofts85518362lofts
loids66220702loids
loins56728422loins
loots55431422loots
lots47652092lo_ts
louts56330272louts
moats75827642moats
moils76125752moils
moist76033582moist
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
nits45741642_nits
noils55024332noils
noirs55615462noirs
nowts86915852nowts
oats46554212_oats
obits74617552obits
oils46337972_oils
omits75018262omits
oots46446442_oots
opts68124742_opts
orts46538332_orts
otitis63612342otitis
outs45746962_outs
pits66348742_pits
poets76024442poets
points85618532points
pois66539042poi_s
ports75934592ports
posits85718712posits
posts75228782posts
pots66452362po_ts
pouts75530322pouts
quits144122352quits
quoits15379682quoits
riots54922012riots
roils54826792roils
roots55933672roots
rotis56327052rotis
rots46454092ro_ts
routs57133412routs
shits84731162shits
sits45050202_sits
skits94721852skits
slits56128852slits
snits54124832snits
softs85019232softs
soils55327982soils
soots55536202soots
sorts54536662sorts
sots45552442so_ts
spits74429552spits
stoats65117482stoats
stoics8311112stoics
stots54828542sto_ts
stotts64612852stotts
stouts65019002stouts
suits55028052suits
tacts76524122tacts
tails55634192tails
tains54936322tains
taints64520532taints
tarts57242022tarts
tats46858132t_ats
tauts56125512tauts
teats55636812teats
tents56434212tents
tests56530192tests
tets45847452t_ets
texts125515042texts
thins85826322thins
this76027382thi_s
tics65729632t_ics
ties45248312t_ies
tils45739612t_ils
tilts55325612tilts
tins45251302t_ins
tints56030922tints
tips66436762t_ips
tis37056642t_i_s
tit36771042t_it_
titi47130612t_iti
titis56023812t_itis
toads65621062toads
toast55831012toast
toasts65914992toasts
tobies84521022tobies
todies74223552todies
tods56141842to_ds
toeas55726422toeas
toes46956442to_es
toffs116016722toffs
toft77441652toft_
tofus86415422tofus
togas67823002togas
togs57242432to_gs
toil46536282toi_l
toile54626492toile
toiles63923512toiles
toilets74112912toilets
toited74016752toited
tokes95234972tokes
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
tomtits937242tomtits
tones56048662tones
tongs65928462tongs
tonics83617862tonics
tons46553052to_ns
tonus56324302tonus
tools55325242tools
toons55027532toons
toot45958882toot_
tooth88020182tooth
tooths96013802tooths
tootsy9437982tootsy
topes76941762topes
tophs105220052tophs
topics104714582topics
topis76025832topis
topos75726392topos
tops66248122to_ps
toras55540372toras
torcs75123762torcs
tores55352672tores
torics85118352torics
tories65435882tories
toros54336192toros
torrs53923562torrs
tors46157382to_rs
tort46967462tort_
torta55925352torta
tortas64918252tortas
torte55431702torte
tortes64826052tortes
torus54329762torus
toss45637972to_ss
tost48351922tost_
tot38884772to_t_
tote46643672to_te
totes55139682totes
tours55325862tours
tout46753822tout_
towies93521192towies
towns86018882towns
tows78545552to_ws
toxics153910202toxics
toxins133314282toxins
toyos87519142toyos
toys78036342to_ys
traits65121982traits
trets55928022trets
tries55742812tries
trigs65423062trigs
trims75021472trims
trios55528092trios
trips74923362trips
trite54730032trite
trois57226092troi_s
trots56629942trots
trouts66116622trouts
tufts85713272tufts
tuis44829642tui_s
tuts45838452t_uts
twats86616602twats
twigs96911172twigs
twins85118982twins
twist86820982twist
twists9549752twists
twit76329062twit_
units54923432units
voids95414672voids
volts85421292volts
vomits112610922vomits
waits88333522waits
whits115923822whits
wits76044872_wits
wonts87621542wonts
worts88631182worts
wots76342892wo_ts
writs86624382writs
zits136030292_zits

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 Filter178691538000.0931921408.6
2DLD Change Limit538002721.69031834.3
3Display Results2722720.0763578.9
 (SQL Overall)1786912721.85996122.1
 
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.