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

93 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
turbeth127471(None) 
turbeths1373351turbeths
turbith1267111turbith
turpeth1284811turpeth
turbit8715112turbit_
turbiths1374082turbiths
turbits969232turbits
turbot8914262turbot_
turbots988022turbots
turpeths1373152turpeths
turret63121852turret_
turrets73010672turrets
barbet104427883barbet_
barbets114915843barbets
beth96629233___beth
burbot10815653burbot_
burbots1168673burbots
buret77444013bur_et_
burets84321263bur_ets
burnet84326173burnet_
burnets93813263burnets
curbed114615873curbe_d
curber104517053curbe_r
curbers115514383curbers
curet75447643cur_et_
curets84922343cur_ets
curvet114720243curvet_
curvets12399913curvets
eurybath1642333eurybath
furbish1536443furbish
furmety1534813furmety
gurnet74920873gurnet_
gurnets84010793gurnets
kurbash1643803kurbash
sorbet83924083sorbet_
sorbets93012513sorbets
sunbath1236423sunbath
surety93515013sur_ety
tarbush1234173tarbush
target75028903target_
targets84314223targets
teeth87315853t__eeth
tercet83624913tercet_
tercets93512443tercets
terete6319333ter_ete
terret63425623terret_
terrets72913583terrets
teth76327893t___eth
thresh12276863thr_esh
toroth95512963tor_oth
tret46653533t_r_et_
trets55928023t_r_ets
troth85622203t_r_oth
trowth1277883t_rowth
truth85214153t_r_uth
tubate82813173tu_bate
tubbed114712223tubbe_d
tubber104313203tubbe_r
tubbers113411253tubbers
tube65828663tu_be__
tubed85818043tu_be_d
tuber75420683tu_be_r
tubers85017033tu_bers
tubes74826453tu_be_s
tucket124219483tucket_
tuckets134810333tuckets
tuffet122612083tuffet_
tuffets13266523tuffets
turban8310483turb_an
turbans939563turbans
turbary1236383turbary
turbid979713turb_id
turbine9310303turbine
turbo71015043turb__o
turbojet1755383turbojet_
turbojets1852553turbojets
turbos8910783turb_os
tureen63312723tur_een
tureens7289873tureens
turfed103110963turfe_d
turgent8712393turgent
turgite837973turgite
turista737443turista
turkey1337763turke_y
turkeys1434523turkeys
turned73914473turne_d
turner63914613turne_r
turners73912893turners
turnery10357423turnery
turreted935373turreted
turves94212693turve_s
tusseh9448423tusse_h
zibeth2034173_zibeth

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.406440125.6
2DLD Change Limit134027936.73319906.0
3Display Results93930.0303100.0
 (SQL Overall)178691937.16924925.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.