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 “fourgons” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
fourgons123483(None) 
fourgon1134861fourgon_
bourbons1245342bourbons
bourdons1136432bourdons
bourgeons1244392bourgeons
forgoes11311352fo_rgoes
forgone1139342fo_rgone
gorgons938852go_rgons
argons75018203__argons
borons85520543bo_r_ons
bourbon1135813bourbon_
bourdon1036423bourdon_
bourgeois1243743bourgeois
bourgeon1144683bourgeon_
bourgs9459993bourg__s
bourns84114063bour__ns
boursins1037513boursins
boutons9310783bou_tons
burgeons1146053_burgeons
burgoos1037123_burgoos
burtons9310853_burtons
cogons96818113co__gons
cordons104415763co_rdons
coupons112710563cou_pons
courlans10117613courlans
diurons838823diur_ons
durions839963_durions
fenurons1174963fenur_ons
flagons1137973f_lagons
fleurons1155343fleur_ons
fluxions1844423fluxions
foisons1047613fo_isons
fordoes11311963fo_rdoes
fordone1149383fo_rdone
foregoes1239523foregoes
foregone1238583foregone
forgers115218183fo_rgers
forges105024263fo_rg_es
forgets113813793fo_rgets
forging124114723fo_rging
forgings13287703fo_rgings
forgo94418333fo_rgo__
forgoer1137693fo_rgoer
forgoers1236413fo_rgoers
forgoing1366853fo_rgoing
forgot104318133fo_rgo_t
formols12299413fo_rmols
fourfold1542213fourfold
fours85521493four___s
foursome1344673foursome
foursomes1444343foursomes
fourteens1243343fourteens
fourths13374953four_ths
frons86124043f__r_ons
fungoes11388813f_ungoes
fungous11367433f_ungous
furans94515953f_ur_ans
furious103110633f_urious
furlong11295413f_urlong
furlongs12304073f_urlongs
furors9310953f_ur_ors
furrows13327793f_urrows
fusions1039153f_usions
futons93911513f_u_tons
godroons1045363godroons
gorgon8310243go_rgon_
hourlong1242733hourlong
jargons1558203_jargons
journos14134943journo_s
kouros1039183kour_o_s
kurgans12145653_kurgans
logons79818173lo__gons
lorgnons943993lo_rgnons
monurons1037093monur_ons
morgans10310123mo_rgans
morgens10310463mo_rgens
morions94014643mo_rions
morons84919543mo_r_ons
morrions1077673morrions
mouflons13133653mouflons
mourns84111013mour__ns
moutons9410313mou_tons
neurons7410443neur_ons
nonagons947223nonagons
organs7912913_o_rgans
orgone71110913_o_rgone
orgones81010793_o_rgones
orlons6411013_o_rlons
outgoes8312643_outgoes
outgone8311463_outgone
outguns8318693_outguns
polygons1447723polygons
sorgos74514663so_rgo_s
soupcons1244373soupcons
soursops1043213soursops
sturgeons1043393sturgeons
surgeons947033_surgeons
turgors836833_turgors
turions7311573_turions
turnons737863_turnons
voudons1135323vou_dons
youpons12265983you_pons

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621027.29620033.2
3Display Results1021020.0303400.0
 (SQL Overall)1786911027.48223882.8
 
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.