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

54 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
benthoses144669(None) 
bathoses13310462b_athoses
benthons1337972bentho_ns
benthos1238372bentho__s
enthuses1138252_enthuses
ethoses10311762_e_thoses
penthouses1546612penthouses
pentoses10312892pent_oses
anetholes1246673anetholes
antheses11311473_antheses
beadhouses1644293beadhouses
bedehouses1644093bedehouses
behoves15177353be__hoves
benches143918603bench__es
benchless1644153benchless
benthon1237693bentho__n
benthonic1644593benthonic
bentos86218303bent_o__s
bentwoods1543993bentwoods
benzoles1936993ben_zoles
bethorns1337323be_thorns
betises94816123be_t_ises
boathouses1545923boathouses
boltholes1445723boltholes
bungholes1543993bungholes
bunkhouses19123393bunkhouses
centeses1079443cent_eses
centones10313663cent_ones
dextroses1745663dextroses
enchases13310273_enchases
encloses10911053_encloses
entases72816273_ent_ases
enthrones12910073_enthrones
enthuse1046963_enthuse_
enthused1245083_enthused
epentheses1563803epentheses
estheses1137783_estheses
ethnoses1146083_e_thnoses
henhouses1546173hen_houses
heptoses1338373hept_oses
ketoses114912873ke_t_oses
menthenes1447703menthenes
menthols1347033mentho_ls
ornithoses13102733ornithoses
orthoses11311133_orthoses
pathoses13412773_pathoses
penthouse1446263penthouse_
pentodes11310363pent_odes
pentose9311593pent_ose_
pestholes1448233pestholes
pesthouses1546243pesthouses
senhores112810993sen_hores
syntheses1545683syntheses
xanthones1957023xanthones

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 Filter1786911486410.406440125.6
2DLD Change Limit148641547.56319653.7
3Display Results54540.0134153.8
 (SQL Overall)178691547.98222386.7
 
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.