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

124 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
flowages153573(None) 
flotages1237151flotages
flowage1435721flowage_
cowages13310932_cowages
floatages1344232floatages
floorages1364972floorages
flotage1136672flotage_
flowerages1743052flowerages
foliages1247622foliages
footages1239042footages
forages114217272f_orages
fromages1437072fromages
lovages1138032_lovages
stowages1236472stowages
towages1139232_towages
asswages1255053asswages
blockages1844063blockages
borages103917163_borages
brewages1436383brewages
brokages1536253brokages
buoyages1443803buoyages
collages113514233collages
cowage12310663_cowage_
cowhages1736103_cowhages
dosages92310803_dosages
dotages92311793_dotages
dowager1245803_dowager
dowagers1334893_dowagers
ecotages1136973ecotages
flags95321283fl__ag_s
flakes134118873fl__akes
flames114723693fl__ames
flanes94522423fl__anes
flanges113413273fl_anges
flares94521703fl__ares
flatwares1544763flatwares
flaxes165015353fl__axes
fledges12409373fl_edges
floatage1244403floatage_
floated113312703flo_ated
floatel10308013flo_atel
floatels11295663flo_atels
floater104413353flo_ater
floaters112711503flo_aters
floats96816253flo_a_ts
floes85528143flo___es
flogged13528803flo_gged
flogger12449453flo_gger
floggers13387863flo_ggers
flogs95919963flo__g_s
flokatis1543123flokatis
flongs105010493flo_ng_s
floorage1275083floorage_
floosies113210233floosies
floozies20326953floozies
floppies1546813floppies
florae94713883flora_e_
florals104210063flora_ls
floras94715693flora__s
florigen12154633florigen
florigens13133863florigens
flosses103411973flo_sses
flossies112810123flossies
flotas94013003flota__s
flounces1335103flounces
flowed133513763flow__ed
flower124815503flow__er
flowerage1643093flowerage_
flowered1546013flowered
flowerer1435453flowerer
flowerers1544503flowerers
floweret1448083floweret
flowerets1544043flowerets
flowers133413173flow_ers
flows115822363flow___s
flyways19133853flywa_ys
foggages1434213foggages
folates103218453f_olates
foliage1147533foliage_
foliaged1344673foliaged
foliates11412753foliates
footage1148833footage_
forage104616993f_orage_
foraged124812273f_oraged
forager114412553f_orager
foragers12349623f_oragers
forges105024263f_o_rges
fromage1336753fromage_
frontages13116183frontages
frottages1384983frottages
helotages1346123helotages
homages131011583_homages
lavages1138603_lavages
linages8813173_linages
loaves94813853_lo_aves
locales93715093_locales
locates93218813_locates
lockages1536723_lockages
lodges86820143_lo_dges
loges66534203_lo__ges
longes75925573_lo_nges
lounges84811353_lounges
lovage1037353_lovage_
lowes85732463_low__es
moorages1139043moorages
nonages8313843_nonages
peonages1138473peonages
pilotages1245503pilotages
plages94520153pl__ages
plottages1244243plottages
plumages1335653plumages
potages102416423_potages
rootages939093rootages
sewages1139753_sewages
socages101012053_socages
storages9311103storages
stowage1136703stowage_
swages104417073__swages
tollages92410193tollages
towage1039833_towage_
ullages838953ul_lages
voltages1237253voltages
voyages1435703_voyages
wages95330933___wages

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.233766914.2
2DLD Change Limit1461621248.69016819.6
3Display Results1241240.0631968.3
 (SQL Overall)1786911248.98619885.5
 
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.