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

90 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
rontgens94468(None) 
roentgens1042691roentgens
rontgen835171rontgen_
ionogens956822ionogens
roentgen942982roentgen_
antigens9310603_antigens
canteens1038573canteens
congees103517923con_gees
congers104223233con_gers
conges94928173con_ge_s
contains10316533contains
contemns1237403contemns
contend103511893cont_end
contends112810573cont_ends
content94326153cont_ent
contents104018213cont_ents
contes84432913cont_e_s
frontages13116183frontage_s
frontenis1243423front_enis
frontes104214163front_e_s
frontiers1254993frontiers
frontless1235403frontless
frontlets1244233frontlets
frontmen1344423frontmen_
frontons1136503front_ons
ionogen837123ionogen_
longans84510813lon_gans
longers84819543lon_gers
longes75925573lon_ge_s
mongers104217273mon_gers
monogeny1446133monogeny
montages111412183montage_s
montanes101114523montanes
montes84226933mont_e_s
morgens10310463mo_rgens
nonages8313843nonage_s
nonagons947223nonagons
onagers838103_onagers
ontogeny1244793_ontogeny
outguns8318693_outguns
oxygens1843163_oxygens
pangens103112063pan_gens
pongees104212543pon_gees
pontes83627853pont_e_s
pontons93315553pont_ons
pontoons10279313pontoons
posteens10309733posteens
poteens92910883po_teens
potteens10256793potteens
rangers83621043ran_gers
ranges73826923ran_ge_s
ranters73323643rant_ers
ratteens8256053ratteens
rattens74213403r_attens
renegers9248793renegers
reneges82513593renege_s
renters74224813rent_ers
rentes65431193rent_e_s
rentiers83311763rentiers
ringent8315153rin_gent
ringers83922953rin_gers
rogers74517913ro__gers
rondels82510053ron_dels
ronions73313343ron_ions
ronnels7318613ron_nels
ronyons10258433ron_yons
rootages939103rootage_s
rooters74522933root_ers
rootles73215633rootle_s
rootless83910443rootless
rootlets8308653rootlets
rosters73727543rost_ers
rotes56143903ro_t_e_s
rotguts833763ro_tguts
rotten64115433ro_tten_
rotters74421393ro_tters
rottes64524833ro_tte_s
rouens64814443ro__uens
rouges76022383ro_uge_s
roughens12286893roughens
routers74822873rout_ers
routes66129313rout_e_s
routines82214363routines
rowens94515303ro__wens
softens10347623soft_ens
tongers84116013ton_gers
tontines82114733tontines
wontons103310533wont_ons
wrongers12327773wron_gers
youthens1435383youthens

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 Limit146162907.72018932.9
3Display Results90900.0461956.5
 (SQL Overall)178691907.92222556.3
 
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.