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

175 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
flotage113668(None) 
floatage1244401floatage
flotages1237161flotages
flowage1435721flowage
footage1148841footage
dotage82711612_dotage
ecotage1036882ecotage
floatages1344232floatages
floorage1275092floorage
florae94713882flora_e
flota85315642flota__
flotas94013002flota_s
flowages1535732flowages
foliage1147532foliage
footages1239052footages
forage104617002f_orage
fromage1336752fromage
frontage1296242frontage
frottage1245082frottage
helotage1245712helotage
lovage1037352_lovage
pilotage1145372pilotage
plottage1144432plottage
potage92715902_potage
rootage839052rootage
voltage1136862voltage
agiotage1043563agiotage
blockage1744103blockage
borage93917013_borage
brokage1436673brokage
buoyage1344293buoyage
cabotage1345223cabotage
cartage10312593cartage
clothe114712993clot_he
cloture9238453cloture
collage102813753collage
cottage104210573cottage
cowage12310663_cowage
cuttage10318343cuttage
dosage82810003_dosage
dotages92311793_dotages
ecotages1136973ecotages
flag87427083fl__ag_
flags95321283fl__ags
flake125119973fl__ake
flame105124443fl__ame
flange103411973fl_ange
flare84823633fl__are
flatmate1346393flatmate
flatware1444883flatware
fledge11439293fl_edge
flite85424963flit__e
float85928573flo_a_t
floatable1444983floatable
floated113312703floated
floatel10308013floatel
floater104413353floater
floatier1136983floatier
floats96816253flo_ats
floaty124210943flo_aty
floe76129773flo___e
flog85523893flo__g_
flogged13528803flo_gged
flogger12449463flo_gger
flogs95919963flo__gs
flokati1443483flokati
flong95815683flo_ng_
flongs105010493flo_ngs
flooie93712153flo_oie
floorages1364983floorages
floosie10378933floosie
floozie19295453floozie
flora85317103flora__
floral94313813flora_l
florals104210063florals
floras94715693flora_s
florigen12154633florigen
flossie10337443flossie
flotsam1244613flotsam
flotsams1343383flotsams
flounce1235413flounce
flowerage1643103flowerage
flute86823753flut__e
flyte115713943flyt__e
foggage1334113foggage
folate93320393f_olate
foliaged1344673foliaged
foliages1247623foliages
foliate10513533foliate
folktale1542873folktale
footbag1344553footbag_
footbags1444523footbags
footie94718133foot_ie
footle93914383foot_le
footpace1544493footpace
footrace1346413footrace
footsie1047643footsie
foraged124812283f_oraged
forager114412563f_orager
forages114217283f_orages
forge95126943f_o_rge
fromages1437073fromages
frontages13116183frontages
frontpage15102633frontpage
frottages1384993frottages
fruitage1244343fruitage
globate1057823globate
helotages1346123helotages
homage121210603_homage
hostage113111233hostage
lavage1038263_lavage
linage7713403_linage
loathe94211383_loathe
lobate82915243_lobate
locale83915653_locale
locate83919843_locate
lockage1436613_lockage
lodge76520083_lo_dge
loge56837193_lo__ge
longe66626463_lo_nge
lota47233503_lota__
lotah85315853_lota_h
lotahs9479873_lotahs
lotas55926303_lota_s
lotte54923853_lot_te
lounge75211213_lounge
lovages1138033_lovages
meltage1037953meltage
metage93114453_metage
mintage101110123mintage
montage101211713montage
moorage1038743moorage
nonage7313683_nonage
notate63217863_notate
offstage1541903offstage
onstage838363onstage
outage72017533_outage
peonage1048723peonage
pilotages1245503pilotages
plage84520403pl__age
platane93112303platane
plottages1244243plottages
plumage1245503plumage
portage103013643portage
postage103214853postage
potages102416423_potages
pottage103310603pottage
protege1059153protege
restage83316183restage
rootages939103rootages
rotate63320343_rotate
sabotage1144593sabotage
scutage1036333scutage
septage1078403septage
shortage1236303shortage
socage91012123_socage
stage65330193__stage
storage8310473storage
stowage1136703stowage
tentage81010643tentage
tollage82610163tollage
towage1039833_towage
ullage739043ul_lage
unitage838993unitage
upstage10167443upstage
vantage11109893vantage
ventage11109623ventage
vintage11128143vintage
voltages1237253voltages
voyage1335473_voyage
waftage14115323waftage
wantage11119623wantage
wastage11109253wastage
wattage1186983wattage
zlote143912943zlot__e

Search took 7 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271756.17321711.8
3Display Results1751750.0632777.8
 (SQL Overall)1786911756.37628025.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.