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

135 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
pinfold133623(None) 
infold10128161_infold
pinfolds1445141pinfolds
bifold1237222bi_fold
enfold10137612_enfold
fanfold1485372fanfold
infolds11137022_infolds
kinfolk1363602kinfolk
ninefold1243242ninefold
pinfolded1643332pinfolded
pinhole122010432pinhole
pinole83218782pin_ole
sixfold1842722sixfold
tenfold1145712tenfold
unfold10179702_unfold
billfold1443153billfold
blindfold1661653blindfold
cineol8108203cineol_
cineole91010003cineole
cineols9128853cineols
enfolds11136253_enfolds
eyefold1443343eyefold
fanfolds15104073fanfolds
finfoot1347173finfoot
fivefold1852553fivefold
fold86528943___fold
indol63714873_indol_
indole74516053_indole
indols74714203_indols
infall939403_infall
infield1135823_infield
infill938413_infill
inflow1235293_inflow
info75617353_info__
infolded1375663_infolded
infolder1256433_infolder
inform11310153_inform
infos84311673_info_s
inroad737933_inroad
insole63515863_insole
kinfolks1453013kinfolks
kinsfolk1442003kinsfolk
lintol6369473lintol_
lintols7339553lintols
mangold1137213mangold
manifold1484943manifold
manyfold1792743manyfold
menfolk1643883menfolk
nailfold1242303nailfold
nonfood1156653nonfood
onefold1144493onefold
painful1246403painful_
panful1179743panful_
panfuls1237173panfuls
piaffed1693753piaffed
piccolo1354403piccolo
piebald1245503piebald
piefort1249533piefort
piehole12188553piehole
piffle14418233pi_ffle
piffled16366403piffled
pignoli1045443pignoli
pinafore1344513pinafore
pinafored1543223pinafored
pinball1137933pinball
pinbone1138183pinbone
pinched153812453pinched
pineal84817683pineal_
pineals93212843pineals
pined85935323pin__ed
pinewood1445403pinewood
pinfish15319303pinfish
pinfolding1743013pinfolding
pinged104321383pin_ged
pingo87122713pingo__
pingoes105116523pingoes
pingos95317673pingo_s
pinguid1146243pinguid
pinhead13347073pinhead
pinholes131810663pinholes
pinion83815893pinio_n
pinioned1137513pinioned
pinions93413603pinions
pinitol936683pinitol_
pinitols1046103pinitols
pinked134819883pin_ked
pinkly155012243pin_kly
pinko115618253pinko__
pinkoes135512313pinkoes
pinkos125313873pinko_s
pinnal84814273pinnal_
pinned94818383pin_ned
pinnula934913pinnula
pinnule936003pinnule
pinocle1138143pinocle
pinoles93418703pin_oles
pinon76024533pin_o_n
pinons86019943pin_ons
pinot78737293pin_o_t
pinots85920273pin_ots
pintle83818263pin_tle
pinto75625753pinto__
pintoes95117713pintoes
pintos86021293pinto_s
pinwale1257843pinwale
pinweed1346933pinweed
pinwork16107243pinwork
pinworm1467183pinworm
pinyon11459763pinyo_n
pinyons12299003pinyons
pistol83313333pistol_
pistole92414313pistole
pistoled11259593pistoled
pistols93213983pistols
pitfall1245823pitfall
plafond1344183plafond
premold1247863premold
presold1059603presold
pretold1049083pretold
refold103812113_refold
sinful938803sinful_
tenfolds1244413tenfolds
tinfoil1044633tinfoil
tinfoils1144323tinfoils
tinful938043tinful_
tinfuls1036593tinfuls
trifold1136243trifold
twofold1442283twofold
unfolds11146803_unfolds
unfond10149113_unfond
unmold9148313_unmold
unsold71410513_unsold
untold7149683_untold
upfold12124953_upfold
zincoid1946663zincoid

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.406440125.6
2DLD Change Limit1340271356.03022226.7
3Display Results1351350.0462934.8
 (SQL Overall)1786911356.48227567.3
 
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.