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

48 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
adjourn156343(None) 
adjourns1662861adjourns
adjoin14107292adjo_in
adjourned1842062adjourned
adjure1435842adj_ure
adnoun757032adnou_n
adorn64917092ad_o_rn
sojourn1442892sojourn
abjure1536743abj_ure
acorn75616623a_co_rn
adjoins1585983adjoins
adjoint15108283adjoint
adjourning1981573adjourning
adjured1634883adj_ured
adjurer1534823adj_urer
adjures1536233adj_ures
adjuring1735103adj_uring
adjuror1542893adj_uror
adjust1447183adj_ust
adnouns835453adnouns
adore65723673ad_o_re
adorns74212613ad_o_rns
adown95611663ad_o_wn
adsorb946953adso_rb
adwoman1345433adwoman
adwomen1345683adwomen
ajowan1634893a_jowan
amour75014853a_mour_
amours83512663a_mours
arbour84211333arbour_
arbours93910043arbours
ardour74110903ardour_
ardours8368883ardours
armour84411853armour_
armours9389853armours
armoury12376233armoury
attorn6310793atto_rn
auburn836213a_uburn
bourn75518483__bourn
dour56330433_d_our_
doura66518663_d_oura
durn56127633_d__urn
journo13135293__journo
mourn77215013__mourn
odour64710493od_our_
odours7418253od_ours
sojourns1542313sojourns
yourn87512773__yourn

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.406440125.6
2DLD Change Limit134027486.45320769.7
3Display Results48480.0301600.0
 (SQL Overall)178691486.88925938.6
 
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.