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

113 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
pipetted133526(None) 
pipette1137941pipette_
pipettes1237561pipettes
dipnetted1343352dipnetted
petted94121522__petted
pileated112711132pileated
pipestem1443742pipestem
pitted94319592pi__tted
rivetted12226092rivetted
abetted1058323_abetted
betted94721163__betted
biparted1335133biparted
bisected1336203bisected
bitted94418483bi__tted
curetted1137173curetted
dieted83115493di_e_ted
digested11208163digested
dinette8310013dinette_
dinettes9310193dinettes
directed1238233directed
diverted13199583diverted
divested13268213divested
duetted937023_duetted
expected2036743expected
experted1838053experted
facetted1445743facetted
fetted104817893__fetted
fileted1159093file_ted
fitted104716663fi__tted
fretted113411853_fretted
gazetted19234853gazetted
gibbetted1542213gibbetted
gitted84015053gi__tted
ideated9310973_ideated
inputted1134663inputted
insetted9249023insetted
jetted143915083__jetted
kitted115114833ki__tted
letted74118543__letted
lineated9711063lineated
netted74118713__netted
palette93613983palette_
palettes103112833palettes
papered122513173pape_red
parented11912213parented
pargetted1345663pargetted
patented1188893patented
patted94724683__patted
pelted94617763__pelted
petter83924773__petter
pettled103611513__pettled
picketed17167383picketed
picoted1239213pi_coted
picrated132110113picrated
pieced113912103pi_e_ced
pierced12347593pi_erced
pieties9419223pi_eties
pigmented1544063pigmented
pileate93815923pileate_
piloted10310323pi_loted
pinnated11338553pinnated
pinsetter1145013pinsetter
pipeage1236203pipeage_
pipeages1336423pipeages
piped105123163pip___ed
pipelined14164853pipelined
pipestems1542833pipestems
pipet95533323pipe_t__
pipets105714773pipe_t_s
pipetting1435513pipetting
pipped104516543pip__ped
pirated102515613pi_rated
pirouetted1342943pirouetted
pitapatted1551133pitapatted
pithed124615613pi__thed
pitied94017253pi__tied
pivoted1336513pi_voted
platted103614263p_latted
pleated103816633p_leated
plotted104612373p_lotted
popeyed1535713pope_yed
potted94624013__potted
prettied1159253p_rettied
priested1138393priested
proette9312363proette_
proettes10312763proettes
pupated12319353pup_ated
putted94220253__putted
repeated113117443repeated
repented112614983repented
repotted1139283repotted
retted74826313__retted
revetted122210943revetted
rewetted12228353rewetted
ripened1038203ripe_ned
riposted11216933riposted
riveted11258573rive_ted
spatted104014143_spatted
spitted103912703_spitted
spotted103713143_spotted
stetted82610403_stetted
tiptoed1036143tip_toed
unletted9310313unletted
unpitted1148623unpitted
unpotted11108393unpotted
unwetted1238123unwetted
vetted104316323__vetted
vidette1167543vidette_
videttes1266333videttes
vignetted1443493vignetted
wetted103717023__wetted
whetted14256693_whetted
witted104216813wi__tted

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621137.26620115.9
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.71823152.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.