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

81 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
turpeth128481(None) 
turbeth1274711turbeth
turpeths1373151turpeths
turbeths1373352turbeths
turbith1267112turbith
turret63121852turret_
turrets73010672turrets
buret77444013bur_et_
burets84321263bur_ets
burnet84326173burnet_
burnets93813263burnets
burped116215503burpe_d
carpet104530093carpet_
carpets113915333carpets
curet75447643cur_et_
curets84922343cur_ets
curvet114720243curvet_
curvets12399913curvets
furmety1534813furmety
gurnet74920873gurnet_
gurnets84010793gurnets
puppet93514593puppet_
puppets10317013puppets
surety93515013sur_ety
tapeta8310693t_apeta
tappet103820113tappet_
tappets113610013tappets
target75028903target_
targets84314223targets
teeth87315853t__eeth
tempeh13357463tempe_h
tercet83624913tercet_
tercets93512443tercets
terete6319333ter_ete
terpene92310863terpene
terret63425623terret_
terrets72913583terrets
teth76327893t___eth
thresh12276863thr_esh
tippet103917873tippet_
tippets11339373tippets
toroth95512963tor_oth
torpedo1035053torpedo
towpath1544043towpath
tret46653533t_r_et_
trets55928023t_r_ets
troth85622203t_r_oth
trowth1277883t_rowth
trumpet113810723trumpet_
trumpets12315573trumpets
truth85214153t_r_uth
tucket124219483tucket_
tuckets134810333tuckets
tuffet122612083tuffet_
tuffets13266523tuffets
tumped114216233tumpe_d
tupelo836483tu_pelo
tupped114013233tuppe_d
turbit8715113turbit_
turbiths1374083turbiths
turbits969233turbits
turbot8914263turbot_
turbots988023turbots
tureen63312723tur_een
tureens7289873tureens
turfed103110963turfe_d
turgent8712393turgent
turgite837973turgite
turista737443turista
turkey1337763turke_y
turkeys1434523turkeys
turned73914473turne_d
turner63914613turne_r
turners73912893turners
turnery10357423turnery
turps74918733turp__s
turreted935373turreted
turves94212693turve_s
tusseh9448423tusse_h
urped84615283_urpe_d
warpath1545203warpath

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 Filter1786911340270.420425454.8
2DLD Change Limit134027816.84619577.4
3Display Results81810.0302700.0
 (SQL Overall)178691817.29624491.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.