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

114 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
toolers7441650(None) 
coolers93522491coolers
poolers94217421poolers
toilers74116261toilers
tollers73217461tollers
tooler63818611tooler_
tooters73818771tooters
tootlers8289501tootlers
woolers104214021woolers
boilers93417062boilers
boodlers113710742boodlers
boogers104514632boogers
bookers134016612bookers
boomers114115912boomers
boozers183912442boozers
bowlers123715782bowlers
cholers124215202cholers
coalers94419352coalers
coilers93619902coilers
cooers84324562coo_ers
cookers134619462cookers
cooler84824712cooler_
coopers114019482coopers
cooters94525722cooters
doodlers10338842doodlers
doolees83711612doolees
doozers17419292doozers
foolery1336692foolery
footers104618332footers
footlers113910792footlers
foozlers20346072foozlers
fowlers133411202fowlers
gaolers83511562gaolers
goobers10219622goobers
hollers103818232hollers
hoofers134513322hoofers
hookers144916512hookers
hoopers123616482hoopers
hooters104520472hooters
hoovers134312702hoovers
howlers133312352howlers
lollers72713792lollers
lookers114014072lookers
loopers93914032loopers
looters74419162looters
moilers93615202moilers
mooleys1236862mooleys
mooners94015342mooners
mooters93818622mooters
noosers74913922noosers
oglers74313182_oglers
oilers64721192_oilers
polers84225642_polers
pollers93420022pollers
pooler83819842pooler_
rollers73117472rollers
roofers105013902roofers
roomers95416412roomers
roosers74217872roosers
rooters74522932rooters
sooners73916642sooners
spoolers10349362spoolers
stookers12449792stookers
stoopers103711302stoopers
tailers73720182tailers
talers64628142t_alers
tellers73717592tellers
thalers106212262thalers
tholes94919782thole_s
tilers63523502t_ilers
tillers73418742tillers
tochers123413092tochers
toddlers10346962toddlers
toeless72612392toeless
togglers10276952togglers
toiler63918282toiler_
toiles63923512toile_s
toilets74112912toilets
tokers104818892t_okers
tolars64817942t_olars
toles55147132t_ole_s
toller63819442toller_
toners64128002t_oners
tongers84116012tongers
tonlets73212502tonlets
tonners73816402tonners
toolbars1044742toolbars
tooled74918902toole_d
toolless836342toolless
tools55325242tool__s
tooter64420802tooter_
tootler73511122tootler_
tootles72915602tootle_s
topers85025322t_opers
topless92511122topless
toppers113914602toppers
tossers74713502tossers
toters65026362t_oters
totters74618732totters
tourers73512742tourers
touters74018352touters
towers94423672t_owers
toyers95516332t_oyers
toyless10268712toyless
trollers83211212trollers
troopers10289442troopers
trovers103713322trovers
twofers1364052twofers
wooers93712442woo_ers
woofers133810582woofers
woolens10398842woolens
wooler93615872wooler_
yodlers11298922yodlers
yowlers13328922yowlers

Search took 4 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 Filter1786911076710.390458182.1
2DLD Change Limit1076711143.45331181.9
3Display Results1141140.0303800.0
 (SQL Overall)1786911143.87346137.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.