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

93 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
surgeons94703(None) 
burgeons1146051burgeons
sturgeons1043391sturgeons
surgeon837001surgeon_
bourgeons1244392bourgeons
burgeon1036432burgeon_
dudgeons11163942dudgeons
dungeons10124622dungeons
gudgeons11113942gudgeons
sturgeon943302sturgeon_
surgers83517482surge_rs
surges73924592surge__s
argons75018203_arg_ons
bludgeons1342803bludgeons
bourgeois1243743bourgeois
bourgeon1144683bourgeon_
burdens1039713burde_ns
burgees104915893burge_es
burgeoned1343703burgeoned
burgers103918573burge_rs
burgess10409343burge_ss
burgoos1037123burg_oos
burtons9310853bur_tons
dudgeon10134143dudgeon_
dungeon9134553dungeon_
durions839963dur_ions
fourgons1234833fourg_ons
gorgeous1046293gorgeous
gorgons938853gorg_ons
gudgeon10123743gudgeon_
gurges84716863gurge__s
hugeous1137133hu_geous
jargons1558203jarg_ons
jargoons1644663jargoons
kurgans12145653kurg_ans
lorgnons943993lorgnons
morgens10310463morge_ns
mureins9310733mur_eins
nucleons1065483nucleons
pereons92815003per_eons
pigeons1039183_pigeons
purgers104714003purge_rs
purges94421763purge__s
sarges75128593sarge__s
sargos74318273sarg_o_s
sarsens7311393sarse_ns
screens95212183scr_eens
sereins73716113ser_eins
sergeant9129403sergeant
sergeants10115593sergeants
sergers83815633serge_rs
serges74225973serge__s
sermons9311783ser_mons
sirens65318153sir_e_ns
smidgeons13272733smidgeons
sorghos11327603sorgho_s
sorgos74514663sorg_o_s
spurges104111653spurge__s
suasions838783suasions
subdeans1137203subdeans
subgenus1145753subgenus
subregions1344423subregions
subteens1037423subteens
suctions103012903suctions
suddens9308783sudde_ns
suggests1044713suggests
summons1158003su_mmons
sunglows1244083sunglows
surfeits1146223surfeits
surfers103614133surfe_rs
surge65027693surge___
surged84118883surge__d
surgeonfish1861013surgeonfish
surger74320093surge__r
surgeries10311363surgeries
surgery11319213surge_ry
surging93115433surg_ing
surreys10489443surre_ys
surveils1144523surveils
surveyors1542293surveyors
surveys13357573surve_ys
syrens94911993syr_e_ns
trudgeons11202843trudgeons
tureens7289873tur_eens
turgent8712393turge_nt
turgors836833turg_ors
turions7311573tur_ions
turnons737863tur_nons
urgent73816043_urge_nt
urgers73313623_urge_rs
urges64619913_urge__s
widgeons1343853widgeons
wigeons1136983_wigeons

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 Filter1786911461620.410435831.7
2DLD Change Limit146162938.04618165.8
3Display Results93930.0462021.7
 (SQL Overall)178691938.50221017.5
 
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.