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

165 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
flashings1631666(None) 
flashing153711551flashing_
fleshings16335381fleshings
lashings124412251_lashings
slashings13316201slashings
bashings144311242_bashings
blastings12347912blastings
clashing143812192clashing_
fashing144918792f_ashing_
fastings124011942f_astings
fishings15307692f_ishings
flaggings15285182flaggings
flashiness16105282flashiness
flatlings13315822flatlings
fleshing15339302fleshing_
flushing15288832flushing_
lashing114422892_lashing_
lashins103915152_lashin_s
lastings94214422_lastings
lathings12469852_lathings
plashing143311062plashing_
slashing123713412slashing_
washings15419272_washings
abashing1466623abashing_
aliasings1043653alias_ings
ashing107824093__ashing_
askings12519173__askings
bashing135422583_bashing_
bastings114214693_bastings
beastings12387653beastings
blackings18316763blackings
bladings12337753bla_dings
blaggings14324463blaggings
blasting114013433blasting_
blessings1233723blessings
blushing14339333blushing_
bushings14348793_bushings
cashing135022553_cashing_
casings104013513_cas_ings
castings113614053_castings
chasings14318253chas_ings
claddings1433213claddings
clasping133310263clasping_
classing113211793classing_
closings11277673clos_ings
clothings15264433clothings
coastings12357863coastings
crashing143512633crashing_
dashing125917893_dashing_
deashing134210953deashing_
eastings93412953_eastings
elastins82111743elastin_s
facings134511263f_a_cings
fadings12469303f_a_dings
failings123811013f_ailings
fairings12388193f_airings
farmings14298223f_armings
farthings1635233farthings
fascines13310143f_ascines
fashions1437243f_ashions
fashious1446123f_ashious
fasting114522833f_asting_
fatlings12359303f_atlings
feasing113916653feas_ing_
feasting122011323feasting_
fishing143913863f_ishing_
flacking184311793flacking_
flagging14329233flagging_
flagships1843703flagshi_ps
flailing12298923flailing_
flaking154114493fla_king_
flamines13311643fla_mines
flaming134216443fla_ming_
flamingo14274143fla_mingo
flamingos15293093fla_mingos
flamming16357153flamming_
flanging132710583flanging_
flanking164211083flanking_
flapping16298153flapping_
flaring114116803fla_ring_
flashers143912653flash_ers
flashes133916103flash__es
flashguns1641983flashguns
flashier1437103flashi_er
flashiest1557993flashiest
flashily1735473flashi_ly
flatlines12268433flatlines
flatling123410013flatling_
flatting123511253flatting_
flavines1437893fla_vines
flavins1338543fla_vin_s
flavorings1762973flavorings
flawing143812563fla_wing_
flaying143914463fla_ying_
fleshiness16104293fleshiness
fletchings19282863fletchings
flings106715283fl___ings
flockings19314343flockings
floggings15314123floggings
floorings13245093floorings
flossing12247903flossing_
flutings12357373fl_utings
flyings14496063fl__yings
flytings15304793fl_ytings
fraggings15324243fraggings
framings14338133fra_mings
frayings15325993fra_yings
freshing152611023freshing_
frostings1335733frostings
gashing125119233_gashing_
gaskings14427473_gaskings
gassings10438403_gassings
glassines10278043glassines
glassing10329973glassing_
glazings19325753gla_zings
gnashing1336423gnashing_
hashing145020163_hashing_
lacings105013653_la_cings
ladings93814133_la_dings
laggings11298403_laggings
lakings124713513_la_kings
landings103110073_landings
lapwings14274973_lapwings
lasing74727983_las_ing_
lasting84725243_lasting_
lathing114315693_lathing_
laughings1443483_laughings
lawings113611473_la_wings
leashing123310313leashing_
leasings9379843leas_ings
listings93310043_listings
loathings1344213loathings
losings82810623_los_ings
lushing114316113_lushing_
mashing134422243_mashing_
maskings15448753_maskings
moshings14367333_moshings
pashing135120513_pashing_
passings11409873_passings
plaitings12296243plaitings
plankings16326113plankings
plannings12325453plannings
plantings12348403plantings
plasmins12199413plasmin_s
platings113611363pla_tings
playthings1942363playthings
quashing2137093quashing_
raspings11337853_raspings
rushings12387843_rushings
sashing114621473_sashing_
slammings14234123slammings
slashingly1743863slashingly
slatings94011723sla_tings
slattings10346073slattings
sloshing12258823sloshing_
slushing12299643slushing_
smashing143310243smashing_
splashing1535703splashing_
stashing123511583stashing_
swashing15369743swashing_
teachings15296553teachings
thrashings1742783thrashings
trashing122613223trashing_
unlashing1336493unlashing_
washing145119283_washing_

Search took 10 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411658.54617393.0
3Display Results1651650.0762171.1
 (SQL Overall)1786911659.04519755.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.