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 “taupe” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
taupe731416(None) 
tape64538141ta_pe
taupes8212671taupes
ape57251182_a_pe
cape87242782ca_pe
cause75225352cause
coupe96023482coupe
daube85015302daube
drupe85012992drupe
dupe76630602_dupe
etape74413702eta_pe
fauve114712072fauve
gape75134512ga_pe
gauge76117902gauge
gauze155712972gauze
haute89521612haute
jape134923422ja_pe
jaup135316422jaup_
jauped16457902jauped
jaups144810532jaups
jupe134921002_jupe
loupe75319512loupe
mauve104013272mauve
nape65230802na_pe
nappe96114992nappe
pauper103511942pauper
pause75021832pause
rape65041632ra_pe
sauce75121652sauce
saute55028082saute
stupe75217752stupe
supe65932762_supe
table75429602table
tace65342512ta_ce
tache106222372tache
tae38267052ta__e
take84739262ta_ke
tale46154162ta_le
tame66343662ta_me
tamp86133002tamp_
tamped114317042tamped
tamper104618512tamper
tamps95524082tamps
tap57663872ta_p_
tapa65129142ta_pa
taped85327422ta_ped
taper74829772ta_per
tapes75838602ta_pes
tapped113820052tapped
tapper104419612tapper
tappet103820112tappet
taps66050672ta_ps
tare45957622ta_re
targe65227092targe
tarp66936412tarp_
tarps76527112tarps
tarre55825632tarre
tasse54821842tasse
taste55127232taste
tate44748602ta_te
tau36856902tau__
taunt55532282taunt
tauon54816582tauon
taus46342732tau_s
taut47048962tau_t
tauted75317112tauted
tauten64311892tauten
tauter64318022tauter
tauts56125512tauts
tawie84819812tawie
tawpie11339142tawpie
tawse85616502tawse
tazze1339572tazze
tope65946382t_ope
toupee8316132toupee
touse55430672touse
tripe75425382tripe
trope75725802trope
troupe84812432troupe
truce75118692truce
true46725852tru_e
tube65828662t_ube
tule45735872t_ule
tune45635862t_une
tup56037542t_up_
tups65628762t_ups
type96223742t_ype
yaup96618482yaup_
yauped12408332yauped
yauper11368542yauper
yaups105910742yaups

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800911.79629955.5
3Display Results91910.0303033.3
 (SQL Overall)178691911.91993116.7
 
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.