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

119 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
pipette113794(None) 
pipetted1335261pipetted
pipettes1237561pipettes
dinette8310012dinette
palette93613982palette
pileate93815922pileate
pipeage1236202pipeage
pipestem1443742pipestem
pipet95533322pipe_t_
pipets105714772pipe_ts
proette9312362proette
vidette1167542vidette
aigrette946833aigrette
anisette846773anisette
appetite1258493appetite
ariette7312373ariette
bimbette1444753bimbette
biretta947243biretta
burette939853burette
casette9310393casette
curette939783curette
cuvette1235833cuvette
dinettes9310193dinettes
dipnetted1343353dipnetted
diskette1346753diskette
epiphyte1843803epiphyte
fouette1038213fouette
frisette1195483frisette
frizette2093503frizette
fumette1245523fumette
galette84212693galette
gazette17357363gazette
genette838863genette
grisette994653grisette
ideate7313683_ideate
layette1037133layette
licente91210893licente
lineate7815153lineate
lisente71210703lisente
lunette737483lunette
mimetite1247603mimetite
mofette1296773mofette
mozette1886773mozette
musette938433musette
navette1036983navette
noisette846313noisette
octette946423octette
paillette1145243paillette
paleate94120003paleate
palettes103112833palettes
pallette1039513pallette
palmette1247733palmette
parkette14138023parkette
paupiette1342603paupiette
petite84320653__petite
petted94121523__petted
petter83924773__petter
petti75119453__petti
pettle84116053__pettle
petto76021043__petto
petty105320293__petty
piastre9307893piastre
picante11310523picante
picotee11311473picotee
picrate112014143picrate
picrite111911313picrite
piece96717993pi_e_ce
pierce104010393pi_erce
pieta75421753pi_e_ta
pietas84516503pi_etas
pieties9419223pi_eties
piety105817303pi_e_ty
pileated112711133pileated
pimento1157223pimento
pinene82915643pine_ne
pineta85815563pine_ta
pinetum1145553pinetum
pinite8321243pi_nite
pinnate93613743pinnate
pinsetter1145013pinsetter
pintle83818263pi_ntle
pipage1199143pip_age
pipe86434433pip___e
pipeages1336423pipeages
piped105123163pipe__d
pipeful1445643pipeful
pipelike16166693pipelike
pipeline12149493pipeline
piper96523193pipe__r
piperine122011833piperine
pipers104318663pipe_rs
pipes96030143pipe__s
pipestems1542833pipestems
pipestone1345503pipestone
pipetting1435513pipetting
pipiest113114493pipiest_
pipit95224873pip_it_
pipits104713063pip_its
pirate82322883pi_rate
pirouette1144453pirouette
piste75824603pi__ste
pitta75018693pi__tta
pitted94319593pi__tted
pretty11510873p_retty
proettes10312763proettes
pupate104213123pup_ate
ripest84317933ripest_
riposte9269623riposte
rivetted12226083rivetted
rosette7310373rosette
septette1044763septette
strette7310763strette
syrette1037183syrette
tiptoe838283tip_toe
toilette846683toilette
tonette7310373tonette
vedette1166003vedette
videttes1266333videttes
vignette1245043vignette

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.1561145455.1
2DLD Change Limit1340271197.86017051.8
3Display Results1191190.0462587.0
 (SQL Overall)1786911198.06222164.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.