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

67 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
bobstay144398(None) 
bobstays1543341bobstays
borstal939042borstal
backstay1945963backstay
beastly1277563beastly
bioassay1342653bioassay
blasty115611053blast_y
boast75935703boast__
boasted104113743boasted
boaster94616433boaster
boasts85017923boast_s
bobbery13438353bobbery
bobby114814663bob__by
bobcat12411253bob_cat
bobcats1335993bobcats
bobs86340653bobs___
bobsled12297153bobsled
bobtail1146553bob_tail
bolshy1444883bols_hy
bolster93713423bolster
bonita8312943bonita_
bonitas939453bonitas
bonsai838463bons_ai
boost75132473boost__
boosted104111983boosted
booster94314553booster
boosts86115013boost_s
booty106125913bo_ot_y
borstals1037463borstals
borty105522833bo_rt_y
bosky145612393bo_s_ky
bosomy13509033bo_somy
bossily1237563bossily
bossy105515973bo_s_sy
boston8513043bo_ston
bota66236503bo__ta_
botany1139263bo__tany
botas75328783bo__tas
bothy136713963bo__thy
bounty113411073bount_y
bousy104917843bous__y
bristly12178063bristly
busty105621013b_ust_y
coastal9411043coastal
costa75523733co_sta_
costae85319683co_stae
costal85419513co_stal
costar85518613co_star
costly114012333co_stly
forestay1448193forestay
homestay1645813homestay
hosta85917833ho_sta_
hostas94515823ho_stas
hostly124210863ho_stly
lobster9288853lobster
mobster11299213mobster
moistly1236613moistly
mostly113110943mo_stly
outsay92611873_outsay
outstay1047683outstay
postal84317533po_stal
robotry1244173robotry
robusta944283robusta_
robustas1044353robustas
robustly1342763robustly
stay78333723___stay
toasty9509563toast_y

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.530337152.8
2DLD Change Limit134027678.01616719.9
3Display Results67670.0164187.5
 (SQL Overall)178691678.56220870.2
 
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.