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

247 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
tools5532524(None) 
cools75632631cools
fools86824201fools
mools76027171mools
pools74427701pools
stools65117021stools
toils54527491toils
tolls54728431tolls
tool46735681tool_
toons55027531toons
toots55331871toots
wools84421461wools
atolls65511352atolls
awols84713522awols
boils75427192boils
bolls75531312bolls
bolos75531372bolos
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032boo_s
boots75837972boots
bowls106121432bowls
coals76129602coals
coils75030082coils
cols66553082_cols
coofs105924712coofs
cooks115429142cooks
cool66940492cool_
cooly105525422cooly
coons76737282coons
coops96229642coops
coos67456492coo_s
coots75636842coots
cowls106922212cowls
diols65521012diols
dolls66126922dolls
dols56943052_dols
dooly94821802dooly
dooms85321342dooms
doors65022132doors
drools74412812drools
enols54718402enols
foals85721692foals
foils85025812foils
foods95924162foods
fool75330592fool_
foots85528282foots
fouls87221432fouls
fowls115518892fowls
gaols66717572gaols
goals65521292goals
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912goo_s
hols76946292_hols
hoods95124082hoods
hoofs115721042hoofs
hooks125027122hooks
hooly115022222hooly
hoops105621072hoops
hoots84830242hoots
howls116219222howls
idols65514132idols
jowls156214522jowls
koels94613902koels
kohls12437802kohls
kolos94921212kolos
kooks85217262kooks
lolls512121732lolls
loofs85623782loofs
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122loo_s
loots55431422loots
moils76125752moils
molls75129782molls
mols65948572_mols
moods85224622moods
mool67533862mool_
moola75117032moola
moolas83615592moolas
moons75331002moons
moors74923142moors
moos66051302moo_s
moots75831662moots
noels56418702noels
noils55024332noils
nolos54423352nolos
nooks95420392nooks
noons54125282noons
obols73715862obols
oils46337972_oils
oohs75220692_oohs
oops65232672_oops
oots46446442_oots
owls76022932_owls
polls74627722polls
polos76129912polos
pols66044562_pols
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pool65835952pool_
poons75430972poons
poops94422412poops
poos65949112poo_s
retools73411022retools
roils54826792roils
rolls55326232rolls
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
rotls55620162rotls
shools94919002shools
snools65715872snools
soils55327982soils
sokols10399082sokols
solos54830792solos
sols45448162_sols
sooks94425452sooks
soots55536202soots
sotols63714452sotols
souls55127362souls
spools85115912spools
stooks105115372stooks
stool55619892stool_
stoops85917892stoops
taels56822072taels
tails55634192tails
talls55133432talls
taos45541002tao_s
taxols13328632taxols
teals56234132teals
teels55726372teels
tells55828942tells
telos55424522telos
tels46841692t_els
thiols95112762thiols
thole85620842thole
tholes94919782tholes
tholos94213002tholos
thous86017252thous
tills54631702tills
tils45739612t_ils
tirls54519802tirls
toads65621062toads
tods56141842t_ods
toeas55726422toeas
toes46956442t_oes
toffs116016722toffs
tofts84919242tofts
tofus86415422tofus
togas67823002togas
togs57242432t_ogs
toil46536282toil_
toile54626492toile
toiles63923512toiles
toits55327472toits
tokes95234972tokes
tola45236332t_ola
tolas54532772tolas
told56132202t_old
tole46052902t_ole
toles55147132toles
toll45535262t_oll
tolu45529152t_olu
toluols735822toluols
tolus55024482tolus
tolyls9436962tolyls
tombs97818732tombs
tomes76037382tomes
toms68343492t_oms
tones56048662tones
tongs65928462tongs
tons46553052t_ons
tonus56324302tonus
too38965422too__
took86531072too_k
tooled74918902tooled
tooler63818612tooler
toolers74416502toolers
toom66532932too_m
toon47740632too_n
toot45958882too_t
tooth88020182tooth
tooths96013802tooths
tootle62613812tootle
tootles72915602tootles
tootsy9437982tootsy
topes76941762topes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122t_ops
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torous64319022torous
torrs53923562torrs
tors46157382t_ors
torts56138122torts
torus54329762torus
toss45637972t_oss
totals63115162totals
totes55139682totes
tots46654122t_ots
tours55325862tours
touts54830392touts
towels94314642towels
towns86018882towns
tows78545552t_ows
toyons95512132toyons
toyos87519142toyos
toys78036342t_oys
triols66117802triols
trogs67022602trogs
trois57226092trois
troll54416532troll
trolls64613942trolls
troops85712772troops
trots56629942trots
trows88826182trows
troys86418612troys
twos76718022two_s
viols86118102viols
woods95723032woods
woofs114918002woofs
wool76427372wool_
wooly114417672wooly
woops104917522woops
woos76238802woo_s
yowls115715432yowls
zooks184716942zooks
zooms164415522zooms
zoons144919692zoons
zoos135828802zoo_s

Search took 3 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 Limit538002471.86028924.7
3Display Results2472470.0633920.6
 (SQL Overall)1786912472.01688636.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.