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

84 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
bheesty154249(None) 
behest11314612behest_
behests1235952behests
bheestie1343152bheestie
cheesy14419192chees_y
chesty144610502ch_esty
amnesty1244823amnesty
barest85327693barest_
basest84720493basest_
beast76338643b_east_
beastly1277563b_eastly
beasts84519723b_easts
beauty115410163b_eauty
beechy16397503b_eechy
beefy135313833b_ee_fy
beery105220123b_ee_ry
bees65453383b_ees__
beet66457543b_ee_t_
beets76131443b_ee_ts
beset76739133b_eset_
besets85718803b_esets
best66355323b__est_
bests75932613b__ests
bheesties1443923bheesties
blasty115611053b_lasty
blest76431723b_lest_
bluest84016483bluest_
bluesy11448983blues_y
breast8319633breast_
breasts939703breasts
brees75632553brees__
breezy20295853bree_zy
brevity1534783brevity
busty105621013b__usty
cheeky18448613chee_ky
cheerly15417603cheerly
cheery144913153chee_ry
cheese113812763chees_e
cheesed133910683cheesed
cheeses123613103cheeses
cheesily1654413cheesily
cherty144612473ch_erty
chest104926143ch_est_
chests114916263ch_ests
christy1536623christy
feisty12449293_feisty
freest95318283freest_
geest64829613_geest_
geests75912163_geests
ghees95215553ghees__
ghosty13467213gh_osty
gleety10479193glee_ty
hasty115718763_h_asty
hearty126313633_hearty
hefty146112133_h_efty
heist87030913_heist_
heists96814633_heists
heresy125011233_heres_y
hest75950773_h_est_
hests85829933_h_ests
honesty13378053honesty
majesty1943503majesty
modesty13476983modesty
pesty106421713__pesty
reest54938093_reest_
reests64618893_reests
sheeney13398933sheeney
sheeny124912193shee_ny
sheerly13337703sheerly
sheesh1237813shees_h
sheet84836953shee_t_
sheets93918493shee_ts
shelty124011543sh_elty
shiest95821523shiest_
shyest125511833shyest_
sleety94112653slee_ty
testy85419063__testy
theist9314763theist_
theists1039143theists
thirsty1354083thirsty
weest85026773_weest_
wheezy24244523whee_zy
yeasty12438693_yeasty
zesty176512163__zesty

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.1561145455.1
2DLD Change Limit134027845.81323056.4
3Display Results84840.0165250.0
 (SQL Overall)178691845.98529856.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.