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

52 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
bourgeons124439(None) 
bourgeois1243741bourgeois
bourgeon1144681bourgeon_
burgeons1146051b_urgeons
bludgeons1342802bludgeons
bourbons1245342bour_bons
bourdons1136432bour_dons
bourgeoise1352862bourgeoise
bourgeoned1452542bourgeoned
burgeon1036432b_urgeon_
fourgons1234832fourg_ons
sturgeons1043392sturgeons
surgeons947032_surgeons
bludgeon1242923bludgeon_
boreens9310403bo_r_eens
borneols1046343bo_rneols
borons85520543bo_r__ons
bouillons1143603bouillons
bounteous1144303bounteous
bourbon1135813bour_bon_
bourdon1036423bour_don_
bourgeoises1462603bourgeoises
bourgeoisie1461733bourgeoisie
bourgeoning1552503bourgeoning
bourgs9459993bourg___s
bournes93615023bourne__s
bourns84114063bour___ns
bourrees10127643bourre_es
bourses94014303bourse__s
boursins1037513bour_sins
boutons9310783bou__tons
burdens1039713b_urde_ns
burgees104915893b_urge_es
burgeoned1343703b_urgeoned
burgers103918573b_urge_rs
burgess10409343b_urge_ss
burgoos1037123b_urg_oos
burtons9310853b_ur_tons
courageous1344193courageous
courteous1145813courteous
dudgeons11163943_dudgeons
dungeons10124623_dungeons
fourgon1134863fourg_on_
fourteens1243343fourteens
gorgeous1046293go_rgeous
gorgons938853go_rg_ons
gudgeons11113943_gudgeons
lorgnons943993lo_rgnons
morgens10310463mo_rge_ns
sturgeon943303sturgeon_
surgeon837003_surgeon_
trudgeons11202843trudgeons

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.466383457.1
2DLD Change Limit148641527.50319810.9
3Display Results52520.0134000.0
 (SQL Overall)178691527.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.