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 “inhalers” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

171 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
inhalers116664(None) 
inhaler1068051inhaler_
inhales10511861inhale_s
inhaulers1263241inhaulers
halers94926912__halers
impalers12226972impalers
inhale9411512inhale__
inhaled1169332inhale_d
inhauler1163942inhauler_
inholders1345352inholders
inhumers1364822inhumers
inlayers1135642inlayers
invaders12105302invaders
thalers106212262_thalers
whalers13529702_whalers
anglers84014823an_glers
annealers944563annealers
antlers74014743an_tlers
ashlers10319583ash_lers
balers85626933__balers
behavers16205613behavers
chafers154512743_chafers
chalehs15268803_chalehs
chalets122813473_chalets
chasers123714923_chasers
chawers154412053_chawers
cholers124215203_cholers
coalers94419353_coalers
dealers84118613_dealers
dialers83614303_dialers
empalers12226743empalers
enablers10196913enablers
enchasers1445093enchasers
engagers10246553engagers
enhaloes1197343enhaloes
enhalos1087533enhal_os
enhancers1445103enhancers
entailers976413entailers
exhales1737143exhale_s
finaglers13173893finaglers
finales104016013fin_ale_s
gnawers11356393gn_awers
hailers104017263__hailers
haler85033523__haler_
haleru94212073__haleru
hales85449843__hale_s
halters104619803__halters
halvers133311423__halvers
haters94930403__haters
haulers104012443__haulers
havers124721483__havers
hayers124415943__hayers
hazers184615953__hazers
healers104319463_healers
idealess935653idealess
idlers74012813i__dlers
imagers10107763i_magers
imbalmers1543103imbalmers
impaler11298393impaler_
impales113311763impale_s
inaner62213543in_aner_
inanes62519803in_ane_s
incages103013883incage_s
incases93615973incase_s
inchers123912523in_chers
inciters103210673inciters
incomers1268593incomers
indexers16326373indexers
inditers93311053inditers
indoles83716363indole_s
inducers11326953inducers
indulgers1143803indulgers
infalls1038943infal_ls
infares10313023infare_s
infers93615443in__fers
inflamers1455213inflamers
inflaters1247543inflaters
infolders1385173infolders
infusers11286143infusers
ingates82716913ingate_s
ingathers1344453ingathers
ingles74420873in_gle_s
inhabiters1543403inhabiters
inhabits1355473inhabits
inhalant1147403inhalant
inhalants1244473inhalants
inhalators1344933inhalators
inhaling1239523inhaling
inhauls1035523inha_uls
inhere9313713inh__ere
inheres10315173inh__eres
inholder1276113inholder_
inhumer1275383inhumer_
inhumes1296883inhume_s
initialers1053043initialers
injurers15286123injurers
inkers104018833in__kers
inkles103515653in_kle_s
inkless11348713in_kless
inlaces92512903inlace_s
inlanders1036143inlanders
inlayer1036933inlayer_
inlets63915573in__lets
inliers73110743in_liers
inmates92715783inmate_s
innages82911303innage_s
inners63919353in__ners
innless7288293in_nless
insaner7310443insaner_
insiders947763insiders
insnarers954433insnarers
insoles73516243insole_s
installers1043623installers
insulars8137323insulars
insulters945883insulters
insurers83710133insurers
intakes11310943intake_s
integers937783integers
inters64328053in__ters
intoners889933intoners
invader11146453invader_
invades11118293invade_s
invalids1244743invalids
invars9310003inva__rs
inviters11359643inviters
invokers1534673invokers
involvers1544033involvers
inwalls1037283inwal_ls
jinglers16408763jin_glers
kindlers13318483kin_dlers
kneaders1384713kneaders
kneelers12226213kneelers
knollers12255143knollers
minglers113011293min_glers
nailers73215893_nailers
naleds7469133_n_aleds
namers84517333_n_amers
nibblers12306543nibblers
nigglers10307253nigglers
onagers838103on_agers
pedalers11239393pedalers
pinholes131810663pinhole_s
pinwales1367963pinwale_s
regalers94311133regalers
scalers93817263_scalers
sealers74323553_sealers
shaders115915553_shaders
shakers144015563_shakers
shales94731253_shale_s
shapers124016893_shapers
sharers104720623_sharers
shavers134115093_shavers
signalers1044583signalers
snarers74216663sn_arers
snarlers8298753snarlers
sneakers12308643sneakers
stealers83412203stealers
talers64628143__talers
thaler94613103_thaler_
thawers13428483_thawers
tinglers93710593tin_glers
tinklers12298183tin_klers
unbales92914863unbale_s
unhairers12183273unhairers
unhairs1036373unha_irs
unmakers14256653unmakers
vealers103214293_vealers
vintagers13123903vintagers
walers94824463__walers
whaler124611973_whaler_
whales124716943_whale_s

Search took 7 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621716.45322650.2
3Display Results1711710.0632714.3
 (SQL Overall)1786911716.95225703.5
 
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.