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

109 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
pinitol93668(None) 
pinitols1046101pinitols
finito9310302finito_
lintol6369472lin_tol
pinion83815892pini_on
pinite8321242pinit_e
pinites9319532pinites
pinto75625752pin_to_
pintos86021292pin_tos
pistol83313332pi_stol
binit76431583binit__
binits85716673binit_s
bonito8313433bonito_
bonitos939733bonitos
capitol11258283capitol
cineol8108203cin_eol
digital937063digital
dinitro845563dinitro
finial92814183fini_al
finical1239693finical
finite9316823finit_e
finitely1445663finitely
finites10315923finites
genital849793genital
genitor837273genitor
ignitor8125263ignitor
indol63714873_in_dol
inion54620183_ini_on
initial7311883_initial
inositol843983_inositol
instal6712193_instal
instil61111383_instil
into45026153_in_to_
invital1046953_invital
janitor1436483janitor
lanital7310913lanital
linalol745093linalol
lintel64013993lin_tel
lintols7339553lin_tols
manito8518693manito_
manitos9314053manitos
manitou938463manitou
mannitol1044043mannitol
minimal114010603minimal
minion83416243mini_on
monitor9310723monitor
nicol71113293__nicol
nitinol745143nitinol
niton55418283__niton
opinion946793opini_on
panino8315683panino_
panto76129413pan_to_
pantos85222743pan_tos
penial84120893peni_al
penicil1138833penicil
pentyl1138813pen_tyl
phenetol1344063phenetol
phytol14366563p_hytol
pinata83817223pinat_a
pinatas93711503pinatas
pinball1137933pinball
pineal84817683pin_eal
pineta85815563pinet_a
pinetum1145553pinetum
pinfold1336233pin_fold
pingo87122713pin_go_
pingos95317673pin_gos
pinhole122010433pin_hole
pinier84024693pini_er
piniest93121133piniest
pining93726533pini_ng
pinions93413603pinions
pinko115618253pin_ko_
pinkos125313873pin_kos
pinnal84814273pin_nal
pinole83218783pin__ole
pinon76024533pin__on
pinot78737293pin__ot
pinots85920273pinot_s
pint66963173pin_t__
pinta75727053pin_t_a
pintail9311183pintail
pintas85021393pin_tas
pintle83818263pin_tle
pintoes95117713pin_toes
pints75936223pin_t_s
pinyon11459763pin_yon
pipit95224873pipit__
pipits104713063pipit_s
pistil83915073pi_stil
pistole92414313pi_stole
pistols93213983pi_stols
piston83515923pi_ston
pistou83211843pi_stou
pitiful1245863pitiful
piton76121583p__iton
pivotal1245433pivotal
pontil8315463pon_til
ponton83217643pon_ton
punition1038373punition
punitory1345603punitory
punto75121323pun_to_
puntos85915793pun_tos
santol64515243san_tol
spinto8410663spin_to_
spintos939133spin_tos
visitor1046203visitor
wittol935923wi_ttol
xylitol1742023xylitol

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.1401276364.3
2DLD Change Limit1340271098.37616001.3
3Display Results1091090.0333303.0
 (SQL Overall)1786911098.54920902.0
 
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.