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

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

94 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
tartufe106467(None) 
tartufes1164151tartufes
tartuffe1461901tartuffe
tartare73012682tartare
tartuffes1551622tartuffes
torture738592torture
arbute8311043_arbute
argue64818443_argu_e
argufy1344093_argufy
armure8710133_armure
arouse65019983_arouse
artful968273_artful
astute6310763_astute
attune637983_attune
barbule1137943barbule
barque17239553barqu_e
battue84311003battu_e
capture1138913capture
carafe115416163car_afe
carouse9614423carouse
cartage10312593cartage
carte75940423cart__e
dartle73714833dart_le
earmuff1543063earmuff
facture12108933facture
fortune1068303fortune
marque172410503marqu_e
marquee18218583marquee
mature8313473ma_ture
nature6311263na_ture
nurture736643nurture
partake1339643partake
partite9317133partite
parure8312523par_ure
pasture9311463pasture
rapture937393rapture
startle72511123start_le
startup934963startu_p
startups1033893startups
statue66015323sta_tu_e
stature74410683sta_ture
statute7419323sta_tute
tactful1236163tactful
tactile9310613tactile
tactual936203tactual
tarbush1234173tarbush
tardive1136893tardive
tare45957623tar___e
targe65227103tar__ge
tariff12711363tar_iff
tariffed1533723tariffed
tariffs1334593tariffs
tarre55825633tar__re
tarsus6310513tarsu_s
tart47566183tart___
tartan64217513tart_an
tartana73010193tartana
tartans72615823tartans
tartar63214753tart_ar
tartars73313403tartars
tarted74923373tart_ed
tarter64023563tart_er
tartest72517533tartest
tartier74123263tartier
tartily103511573tartily
tarting84222653tarting
tartish101512633tartish
tartlet72218483tartlet
tartly96014023tart_ly
tartrate899683tartrate
tarts57242023tart__s
tarty86328183tart__y
taste55127233tast__e
tate44748603ta_t__e
tattie64817513ta_ttie
tattle64115653ta_ttle
taupe7314173ta__upe
texture1497083texture
torque15237673torqu_e
torte55431703tort__e
tortile7313193tortile
tortured935843tortured
torturer835493torturer
tortures838913tortures
traduce1036353traduce
triune64210183t_riune
troupe84812433t_roupe
truce75118693t_r_uce
true46725853t_r_u_e
truffe1276233t_ruffe
turtle63213573turt_le
virtue9358673virtu_e
wafture1334853wafture
wartime1237743wartime

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.406440125.6
2DLD Change Limit134027947.62617575.0
3Display Results94940.0303133.3
 (SQL Overall)178691948.06222164.6
 
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.