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

104 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
pipetting143551(None) 
dipnetting1453622dipnetting
petting103720952__petting
pitting103618872pi__tting
rivetting13256412rivetting
abetting1158293_abetting
begetting13186583begetting
besetting12268423besetting
betting103921403__betting
bisecting1436973bisecting
bitting103717293bi__tting
curetting1236573curetting
dieting93616833di_e_ting
digesting12208673digesting
directing1338823directing
diverting142410333diverting
divesting14298483divesting
duetting1047183_duetting
expecting2146693expecting
experting1938053experting
facetting1535283facetting
fetting113517873__fetting
fileting1239303file_ting
fitting113516563fi__tting
fretting122711523_fretting
gazetting2043243gazetting
getting93316563__getting
gibbetting1642313gibbetting
gitting93215703gi__tting
hitting113017273hi__tting
ideating10311703_ideating
inletting1087873inletting
inputting1235823inputting
insetting1079283insetting
jetting153815343__jetting
kitting123214443ki__tting
letting83218533__letting
miseating121215433miseating
missetting13107903missetting
netting84018763__netting
papering132213313pape_ring
parenting12611583parenting
pargetting1444943pargetting
patenting1248943patenting
patting103722343__patting
pelting102917273__pelting
pettings11349703__pettings
pettling1168213__pettling
picketing1835683picketing
picoting1338883pi_coting
piecing12410453pi_e_cing
pieing93917653pi_e__ing
piercing1346663pi_ercing
pigmenting1653713pigmenting
piloting1139693pi_loting
pipeline12149503pipe_line
pipelining1543973pipelining
piperine122011833pipe_rine
pipestone1345503pipestone
pipette1137943pipett__e
pipetted1335263pipett_ed
pipettes1237563pipett_es
piping114017453pip___ing
pipping113414743pip__ping
pirating11314513pi_rating
pirouetting1442693pirouetting
pitapatting1651473pitapatting
pithing134014053pi__thing
pittings11349123pi__ttings
pitying132910243pi__tying
pivoting1436183pi_voting
platting114813033p_latting
pleating112916053p_leating
plotting113011013p_lotting
potting103720893__potting
presetting131010833presetting
prettying1536043p_rettying
priesting1239483priesting
pupating1337683pup_ating
putting103218573__putting
reletting102713943reletting
repeating122618983repeating
repenting122316553repenting
repotting12511123repotting
resetting102816293resetting
retting83425883__retting
revetting132912633revetting
rewetting132710443rewetting
ripening1138573ripe_ning
riposting1236063riposting
riveting12139443rive_ting
setting83621393__setting
sitting83519633si__tting
spatting113111763_spatting
spitting113012323_spitting
spotting112812093_spotting
stetting93410713_stetting
unsetting1088993unsetting
upsetting1275563upsetting
vetting114216563__vetting
vignetting1542823vignetting
wetting114117383__wetting
whetting1535973_whetting
witting113417063wi__tting

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411047.25320493.7
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.71923149.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.