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

102 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
turbith126711(None) 
turbeth1274711turbeth
turbit8715111turbit_
turbiths1374081turbiths
turbits969231turbits
furbish1536442furbish
turbeths1373352turbeths
turbid979712turbi_d
turbine9310302turbine
turbot8914262turbot_
turbots988022turbots
turgite837972turgite
turpeth1284812turpeth
brith104924373_br_ith
burbot10815653burbot_
burbots1168673burbots
burkite1337003burkite
burnish1238623burnish
burrito936223burrito
cubbish1635803cubbish
cubit94122893cu_bit_
cubiti10399083cu_biti
cubits103714033cu_bits
curbing123814023curbing
curite85222943cur_ite
currish1238353currish
eurybath1642333eurybath
frith115922033_fr_ith
furmity1535183furmity
furnish1337383furnish
grith95520373_gr_ith
kurbash1643803kurbash
orbit73622063_orbit_
orbits84211443_orbits
outbitch1543443outbitch
outwith13279133outwith
purity114114913pur_ity
qubit164218993qu_bit_
qubits173710353qu_bits
rubbish1436303rubbish
subito8410453su_bito
sunbath1236423sunbath
tallith102913063tallith
tarbush1234173tarbush
tarnish101611873tarnish
tartish101512633tartish
terbia8311153terbi_a
terbias9310743terbias
terbic10410963terbi_c
terbium1147293terbium
terebinth1443413terebinth
tergite8311003tergite
termite9313893termite
territ63421373territ_
territs72714503territs
tidbit938493tidbit_
tidbits1035183tidbits
titbit839823titbit_
titbits935803titbits
toroth95512963tor_oth
trait56940843t_rait_
traits65121983t_raits
trilith10310513trilith
trite54730033t_r_ite
troth85622203t_r_oth
trowth1277883t_rowth
truth85214153t_r_uth
tubate82813173tu_bate
tubbier11237743tubbier
tubbing123510093tubbing
tubing93813093tu_bing
tubist83013163tu_bist
tubists9288323tu_bists
tundish1137283tundish
turban8310483turb_an
turbans939563turbans
turbary1236383turbary
turbidite12164693turbidite
turbidity15144293turbidity
turbidly1443683turbidly
turbinal1045623turbinal
turbinate1146673turbinate
turbines1039903turbines
turbo71015043turb__o
turbos8910783turb_os
turdine8310283turdine
turfier10249793turfier
turfing113010053turfing
turgid868013turgi_d
turgites937783turgites
turion6313163tur_ion
turista737443turista
turning83713183turning
turnip836593turni_p
turnips935013turnips
turpeths1373153turpeths
turret63121853turret_
turrets73010673turrets
urbia7311143_urbi_a
urbias839093_urbias
urolith1048783_urolith
wraith1258603_wraith

Search took 7 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.390458182.1
2DLD Change Limit1340271026.14021828.5
3Display Results1021020.0333090.9
 (SQL Overall)1786911026.56327227.0
 
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.