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

181 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
flotages123715(None) 
floatages1344231floatages
flotage1136671flotage_
flowages1535731flowages
footages1239041footages
dotages92311792_dotages
ecotages1136972ecotages
floatage1244402floatage_
floorages1364972floorages
flotas94013002flota__s
flowage1435722flowage_
foliages1247622foliages
footage1148832footage_
forages114217272f_orages
fromages1437072fromages
frontages13116182frontages
frottages1384982frottages
helotages1346122helotages
lovages1138032_lovages
pilotages1245502pilotages
plottages1244242plottages
potages102416422_potages
rootages939092rootages
voltages1237252voltages
agiotages1143773agiotages
blockages1844063blockages
blotches1537433blotches
borages103917163_borages
brokages1536253brokages
buoyages1443803buoyages
cabotages1444853cabotages
cartages11313313cartages
clothes124513813clot_hes
clotures10299023clotures
collages113514233collages
cottages113310493cottages
cowages13310933_cowages
cuttages11297223cuttages
dosages92310803_dosages
dotage82711613_dotage_
ecotage1036883ecotage_
flags95321283fl__ag_s
flakes134118873fl__akes
flames114723693fl__ames
flanes94522423fl__anes
flanges113413273fl_anges
flares94521703fl__ares
flatmates1446193flatmates
flatuses1137173flatuses
flatwares1544763flatwares
flaxes165015353fl__axes
fledges12409373fl_edges
fletches16308853fletches
flitches16388463flitches
flites95122443flit__es
floated113312703flo_ated
floatel10308013flo_atel
floatels11295663floatels
floater104413353flo_ater
floaters112711503floaters
floatier1136983floatier
floatiest1237283floatiest
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
flota85315643flota___
flotsams1343383flotsams
flounces1335103flounces
flowerages1743053flowerages
flutes95421783flut__es
flytes123911563flyt__es
foggages1434213foggages
folates103218453f_olates
foliage1147533foliage_
foliaged1344673foliaged
foliates11412753foliates
folktales1653123folktales
footbags1444513footbag_s
footies103721543foot_ies
footles103715713foot_les
footpaces1644633footpaces
footraces1446703footraces
footsies1139643footsies
forage104616993f_orage_
foraged124812273f_oraged
forager114412553f_orager
foragers12349623f_oragers
forges105024263f_o_rges
fromage1336753fromage_
frontage1296243frontage_
frontpages1692643frontpages
frottage1245073frottage_
fruitages1344483fruitages
geotaxes1644743geotaxes
helotage1245713helotage_
homages131011583_homages
hostages122311693hostages
lavages1138603_lavages
linages8813173_linages
loathes103513243_loathes
loaves94813853_lo_aves
locales93715093_locales
locates93218813_locates
lockages1536723_lockages
lodges86820143_lo_dges
loges66534203_lo__ges
longes75925573_lo_nges
lotahs9479873_lota_hs
lotas55926303_lota__s
lotoses73713643_lotoses
lottes65322753_lot_tes
lotuses74011253_lotuses
lounges84811353_lounges
lovage1037353_lovage_
meltages1148243meltages
metages102714973_metages
mintages111110513mintages
montages111412183montages
moorages1139043moorages
nonages8313843_nonages
notates72817483_notates
offstages1652033offstages
outages82317323_outages
peonages1138473peonages
pilotage1145373pilotage_
plages94520153pl__ages
platanes102711883platanes
plottage1144433plottage_
plotties103111413plotties
plotzes18317693plot_zes
plumages1335653plumages
portages112613223portages
postages112815323postages
potage92715903_potage_
pottages112910453pottages
protases102115033protases
proteges1149923proteges
restages92815763restages
rootage839043rootage_
rotates72819773_rotates
sabotages1244433sabotages
scutages1136503scutages
septages1168263septages
shortages1336513shortages
socages101012053_socages
stages75629493__stages
storages9311103storages
stowages1236473stowages
telotaxes1644643telotaxes
tentages91011043tentages
tollages92410193tollages
towages1139233_towages
ullages838953ul_lages
unitages938273unitages
upstages11147373upstages
vantages12119023vantages
ventages12119763ventages
vintages12118273vintages
voltage1136863voltage_
voyages1435703_voyages
waftages15105393waftages
wantages12109023wantages
wastages12109753wastages
wattages12106783wattages
zloties1639913zlot_ies

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.186960704.3
2DLD Change Limit1461621818.50017195.5
3Display Results1811810.0802262.5
 (SQL Overall)1786911818.76620384.6
 
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.