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

56 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
teashops134573(None) 
teashop1246081teashop_
teleshops1444772teleshops
toyshops1644432toyshops
barhops14288113_barhops
bellhops1544873bellhops
bishops1437033_bishops
carhops14329703_carhops
cashoos12310793_cashoos
deanships1545993deanships
deashes113313903deash_es
dramshops1762583dramshops
earshots1146623_earshots
estops84011223_e_stops
headships1845673headships
leashes103514403leash_es
peascods1344063peascods
reasons72514943reas_ons
reships1239863re_ships
reshoes102316033re_shoes
reshows132510453re_shows
seashore1147723seashore
seashores1247963seashores
seasons72614233seas_ons
shops104222903___shops
smashups1543213smashups
steamships1754063steamships
sweatshops1852163sweatshops
teachers133212393teachers
teaches122718353teach_es
teacups1133963tea_cups
teahouse1146073tea_house
teapots939053tea_pots
teapoys1235963tea_poys
teardrops1263293teardrops
tearooms1047843tearooms
teasels74311313teas_els
teasers75317243teas_ers
teases65426273teas__es
teaspoon1044413teaspoon
teaspoons1143843teaspoons
teleshop1344713teleshop_
telsons739213tels_ons
tensions8310223tensions
tensors72712373tens_ors
teraflops1443063teraflops
testons7313553te_stons
toeshoes1147713toeshoes
toyshop1544873toyshop_
tranships14410333tranships
trashers113013643trashers
trashes104119263trash_es
treasons848683treas_ons
tuckshops2052343tuckshops
washups1534683_washups
weasons102310583weas_ons

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 Filter1786911461620.1531167915.0
2DLD Change Limit146162567.03320782.3
3Display Results56560.0163500.0
 (SQL Overall)178691567.20224811.3
 
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.