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

155 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
infolds1113702(None) 
enfolds11136251enfolds
infold10128161infold_
pinfolds1445141pinfolds
unfolds11146801unfolds
enfold10137612enfold_
fanfolds15104072fanfolds
folds95221692__folds
indoles83716362indoles
indols74714202indol_s
infalls1038942infalls
infields1244012infields
inflows1335522inflows
infolded1375662infolded
infolder1256432infolder
infolders1385172infolders
informs1248072informs
infos84311672info__s
inroads837042inroads
insoles73516242insoles
kinfolks1453012kinfolks
pinfold1336232pinfold_
refolds11298952refolds
tenfolds1244412tenfolds
unfold10179702unfold_
unmolds10135742unmolds
upfolds13133752upfolds
affords1435023affords
aholds10469483_aholds
anoles64827433an_oles
beholds1336423beholds
bifold1237223bifold_
billfolds1542773billfolds
blindfolds1751323blindfolds
bolds85825283__bolds
cineoles10109403cineoles
cineols9128853cineol_s
colds85726973__colds
enfolded1345433enfolded
enfolder1286153enfolder
enfolders1395093enfolders
engilds974863engilds
enols54718403en_ol_s
enrolls7108093enrolls
enrols61213383enrol_s
eyefolds1542623eyefolds
fanfold1485373fanfold_
finfoots1444153finfoots
fold86528943__fold_
folks126017123__folks
fonds95824823__fonds
foods95924163__foods
fords95328183__fords
golds75421313__golds
holds94623243__holds
idols65514133i_dol_s
inboards1145843inboards
inbounds11134053inbounds
inbreds10245733inbreds
incogs937903inco_gs
incomes11712373incomes
indol63714873indol__
indole74516053indol_e
indoors838553indoors
indows104210793indo_ws
indults8289493indults
infall939403infal_l
infants102210773infants
infares10313023infares
infects12279713infects
infeoffs1352083infeoffs
infers93615443inf_ers
infests10279793infests
infield1135823infield_
infill938413infil_l
infirms1245563infirms
infixes17238133infixes
inflow1235293inf_low
influx1643723inf_lux
info75617353info___
infolding1445413infolding
inform11310153info_rm
infuses102711873infuses
ingles74420873in_gles
ingots7912063ingo_ts
ingulfs1134733ingulfs
inhales10511863inhales
inholder1276113inholder
inholders1345353inholders
inions64417003inio_ns
inkles103515653in_kles
inkwoods1674083inkwoods
inlands838783inlands
innards837153innards
inpours936423inpours
inroad737933inroad_
insole63515863insol_e
insouls737213insouls
insults7268963insults
intends8239963intends
interfolds14126143interfolds
intombs1144153intombs
intones7816543intones
intorts7310973intorts
invalids1244743invalids
invokes1436383invokes
involve1345093involve
involves1444973involves
inwalls1037283inwalls
inwards1138343inwards
inwinds11216273inwinds
kinfolk1363603kinfol_k
knolls10367413kn_olls
kobolds1474343kobolds
lintols7339553lintol_s
mangolds1235193mangolds
manifolds1583673manifolds
menfolks1742903menfolks
molds85324833__molds
nailfolds1341843nailfolds
nicols8810243nicol_s
ninefold1243243ninefold_
nods55838223_n_o_ds
nolos54423353_n_olos
olds55926573___olds
onefold1144493onefold_
onloads8246673onloads
oxfords1842893oxfords
pinfolded1643333pinfolded
pinholes131810663pinholes
pinoles93418703pin_oles
refold103812113refold_
remolds10299703remolds
scolds95011233_scolds
sixfold1842723sixfold_
snoods74312453sn_oods
snools65715883snool_s
tenfold1145713tenfold_
tinfoils1144323tinfoils
tinfuls1036593tinful_s
twofolds1541613twofolds
unbolts9247803unbolts
unfolded1338313unfolded
unfolder12216583unfolder
unfolders1344723unfolders
unfond10149113unfond_
unhoods1137503unhoods
unloads8278523unloads
unmold9148313unmold_
unrolls797793unrolls
unsold71410513unsold_
untold7149683untold_
upfold12124953upfold_
upholds13135243upholds
wolds95420183__wolds

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271556.00022337.8
3Display Results1551550.0463369.6
 (SQL Overall)1786911556.46927622.7
 
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.