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

173 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
inwalls103728(None) 
infalls1038941infalls
inwall938341inwall_
gingalls1096432gingalls
indwells1243692indwells
infall939402infall_
inhales10511862inhales
inhauls1035522inhauls
inkwells1542562inkwells
installs858922installs
inwalled1275772inwalled
inwards1138342inwards
jingalls1685332jingalls
pinballs1246932pinballs
pinwales1367962pinwales
walls85529382__walls
ainsells895403ainsells
alls46740923___alls
anally9513503an_ally
annals66415923anna_ls
appalls11337743appalls
balls76236413__balls
befalls12349123befalls
begalls10319163begalls
bewails1277553bewails
calls75634733__calls
dewfalls1543073dewfalls
drywalls1542953drywalls
dwells10417713_dwells
enhalos1087533enhalos
enrolls7108093enrolls
entails7912823entails
falls85727653__falls
finales104016013fin_ales
finalis103313663fin_alis
finally13310103fin_ally
finals94316163fin_a_ls
finials103210153finia_ls
firewalls15125353firewalls
gadwalls1343873gadwalls
galls64729323__galls
gingall9117333gingall_
gingals9109313ginga_ls
gnarls74210773gn_arls
gunwales1244733gunwales
halls85633783__halls
hawalas13348353hawalas
icefalls1344253icefalls
ideally1137793ideally
ideals75012503idea_ls
idylls10425253i_dylls
ills47030423i___lls
imbalms1334553imbalms
impalas11236953impalas
impales113311763impales
inanes62519803in_anes
inarms8410093in_arms
incages103013883incages
incants92012803incants
incases93615973incases
indabas1045853indabas
indoles83716363indoles
indols74714203in_dols
indults8289493indults
indwell1143903indwell_
infants102210773infants
infares10313023infares
infill938413infill_
infolds11137023infolds
ingates82716913ingates
ingles74420873in_gles
ingulfs1134733ingulfs
inhale9411513inha_le
inhaled1169333inhaled
inhaler1068053inhaler
inhalers1166643inhalers
inhaul936803inhaul_
inkles103515653in_kles
inkwell1442533inkwell_
inlaces92512903inlaces
inlands838783inlands
inlays9389873inla_ys
inmates92715783inmates
innages82911303innages
innards837153innards
insoles73516243insoles
insouls737213insouls
install779363install_
instals7611713instals
instills867353instills
instils7811453instils
insults7268963insults
intagli845023intagli
intakes11310943intakes
inthralls12216233inthralls
invades11118293invades
invalid1146393invalid
invalids1244743invalids
invars9310003inva_rs
inwalling1385633inwalling
inward10310333inwa_rd
inwardly1543783inwardly
inweaves1445043inweaves
inwinds11216273inwinds
inwraps12105253inwraps
jingall1566173jingall_
jingals1588073jinga_ls
knawels14344683knawels
knells10439253kn_ells
knolls10367413kn_olls
lalls55324133__lalls
linalols844903lin_alols
lineally1137793lineally
lowballs1364393lowballs
malls76233433__malls
miscalls1239003miscalls
nails55730403_n_ails
nalas55528363_n_alas
nills54926673_n_ills
nulls55019983_n_ulls
nyalas936903_nyalas
onwards1137173onwards
palls74332563__palls
pinball1137933pinball_
pineals93212843pinea_ls
pintails10310163pintails
pinwale1257843pinwa_le
pitfalls1345373pitfalls
rainfalls1244143rainfalls
recalls92613623recalls
refalls103312243refalls
scalls84218203_scalls
seawalls1145233seawalls
sidewalls1344283sidewalls
smalls84514123_smalls
snails64816653sn_ails
snarls64016873sn_arls
snells64614203sn_ells
snowballs14114463snowballs
snowfalls15113083snowfalls
spalls84217343_spalls
squalls1647313squalls
stalls64019933_stalls
swails94913123_swails
swales93920763_swales
swells93913983_swells
swills94213363_swills
talls55133433__talls
thralls10299043thralls
tincals93610643tinca_ls
tinwares1137913tinwares
twills9489793_twills
unbales92914863unbales
unnails738223unnails
unrolls797793unrolls
unsells73210773unsells
unwalled1288653unwalled
unwell9349443unwell_
upwells12244303upwells
vinals94716483vin_a_ls
wails86631483__wails
wales86142833__wales
walks126218503__walks
wall76236103__wall_
walla85321033__walla
wallas95719393__wallas
wally114625093__wally
wauls86120553__wauls
wawls115416473__wawls
wells85426193__wells
wills84528963__wills
windfalls1643723windfalls
windgalls1443133windgalls

Search took 9 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271737.83017117.1
3Display Results1731730.0602883.3
 (SQL Overall)1786911738.29621539.4
 
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.