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

71 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
mortgage124421(None) 
mortgaged1442541mortgaged
mortgagee1342851mortgagee
mortgager1342511mortgager
mortgages1344021mortgages
montage101211712mont_age
mortgagees1451702mortgagees
mortgagers1442232mortgagers
mortgagor1351362mortgagor
portage103013642port_age
aortae65115473aort_a_e
borage93917013bor__age
burgage1136633bur_gage
cartage10312593cart_age
cordage11310063cor_dage
corkage1438373cor_kage
corsage1039803cor_sage
cortege1098953cort_ege
cottage104210573co_ttage
dotage82711613do_t_age
foggage1334113fo_ggage
footage1148843foot_age
forage104617003for__age
forgave1435853for_gave
frottage1245083frottage
hostage113111233host_age
marriage1147253marriage
meltage1037953melt_age
metage93114453m_et_age
mintage101110123mint_age
mirage92313653mir__age
montaged12107763mont_aged
montages111412183mont_ages
montane91313623mont_ane
moorage1038743mo_orage
morae75831193mor__a_e
morale85220553mor__ale
morgan9311373mor_ga_n
morgans10310123mor_gans
morgue938113mor_g_ue
mortal84616853mort_a_l
mortals93914013mort_als
mortar83812043mort_a_r
mortared1137213mort_ared
mortars93411523mort_ars
mortary12369043mort_ary
mortgaging1542893mortgaging
mortgagors1451463mortgagors
mortice11711493mort_ice
mortise9713533mort_ise
mortmain1244573mortmain
mortuary1373923mortuary
morulae958963morula_e
moulage1037903mo_ulage
multiage1147983multiage
outage72017533_out_age
outgave11259563_outgave
outgaze17239223_outgaze
outrage82616893_outrage
portaged12228463port_aged
portages112613223port_ages
porterage1245763porterage
postage103214853post_age
postgame1345523postgame
potage92715903po_t_age
pottage103310603po_ttage
rootage839053root_age
shortage1236313short_age
voltage1136863volt_age
vorlage1136403vor_lage
wordage1236503wor_dage

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.420425454.8
2DLD Change Limit146162717.43619656.0
3Display Results71710.0332151.5
 (SQL Overall)178691717.88922650.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.