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

216 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
serfage113840(None) 
serfages1238231serfages
herbage1337002herbage
leafage1194572leafage
seepage1037542seepage
selvage1136552selvage
septage1078402septage
serape84818412ser_ape
serge64727472ser__ge
seriate73722472seriate
serrate73017542serrate
sewage10310732se_wage
surface1238652surface
acreage1037843acreage
aerate64830553aer_ate
airfare1047243airfare
average1158853aver_age
barrage10710843barrage
berake124216083ber_ake
berate84729023ber_ate
bereave1258353bereave
borage93917013bor_age
brewage1347183brewage
burgage1136633burgage
carfare12310073carfare
carnage10311743carnage
cartage10312593cartage
cerate84829463cer_ate
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
deface123113863de_face
defame123212433de_fame
defrag1136463defrag_
defrags1236193defrags
degage92711383de_gage
derange939813derange
derate74531233der_ate
efface14366673_efface
encage93713503_encage
enface112510353_enface
engage82812103_engage
enrage72715073_enrage
erase54925493_er_ase
ergate7315143_ergate
escuage1035113escuage
feriae95618603feria_e
fermate122813003fermate
ferrate103014043ferrate
ferriage1245463ferriage
forage104617003for_age
garage8314513gar_age
garbage1138053garbage
germane1049663germane
herbaged1554523herbaged
herbages1437093herbages
heritage1246533heritage
hermae115314473herma_e
keelage1236183keelage
leafages1244623leafages
leakage1235003leakage
meltage1037953meltage
menage93216543me_nage
merge84523693mer__ge
message1037833message
metage93114453me_tage
mirage92313653mir_age
nervate1039533nervate
overage11514053over_age
peage84723573pe__age
peerage1089803peerage
pelage9515363pe_lage
peonage1048723peonage
percale11314093percale
perfume1446503perfume
perfuse1247663perfuse
pervade1337023pervade
portage103013643portage
preface14510923preface
prefade1339013prefade
presage10312293presage
rage55742353__r_age
reface113616353re_face
reframe1239393reframe
refuge105312613re_fuge
reimage1037913reimage
restage83316193restage
sage55044593s___age
salvage1138193salvage
sarape84817573sar_ape
sarge65531133sar__ge
sausage847193sausage
savage10410173s_avage
scalage103110533scalage
scrag85916173scr_ag_
scrags95713803scr_ags
scrape105917573scr_ape
scrooge1037183scrooge
scrouge1036353scrouge
scutage1036333scutage
seabag938473seabag_
seabags1037483seabags
seafarer1144843seafarer
seaware1049633seaware
sedate73019813se_date
sedge75019973se__dge
seepages1137283seepages
selfsame1342883selfsame
selvaged1334343selvaged
selvages1236513selvages
senate63725173se_nate
sensate7311893sensate
septages1168263septages
septate9511873septate
sera46141393ser_a__
serac75925203ser_a_c
seracs84418573ser_acs
serai56830163ser_a_i
serail64222673ser_ail
serais64326133ser_ais
seral56336383ser_a_l
serapes95218103ser_apes
seraph114011163ser_aph
serdab937833serda_b
serdabs1035323serdabs
sere46153473ser___e
serenade9218343serenade
serenate81914883serenate
serene63522353ser_ene
serf76340113serf___
serfdom1344213serfdom
serfish1348973serfish
serflike1536273serflike
serfs84922013serf__s
serged84118773ser__ged
serger73819743ser__ger
serges74225973ser__ges
serial64625863seria_l
serials73919753serials
seriated92717023seriated
seriates82620673seriates
serine65432673ser_ine
sering74731813sering_
seringa83310743seringa
serosae7310243serosae
serpigo1044833serpigo
serrano768463serrano
serrated92513433serrated
serrates82617023serrates
servable13310093servable
serval93913413serva_l
servals103410753servals
servant10313633servant
serve85425963ser__ve
service1239093service
servile10310643servile
sesame8311013se_same
setae56026223se_ta_e
sewages1139753se_wages
sewerage1245513sewerage
shortage1236313shortage
signage937773signage
silage72715303s_ilage
sinkage1287263sinkage
soakage1236103soakage
socage91012123s_ocage
soccage1236283soccage
soilage8169353soilage
solfege1144223solfege
sorbate9311733sorbate
spinage10289653spinage
sprag86418693spr_ag_
sprags95715823spr_ags
springe103913983springe
stage65330193s__tage
stealage946583stealage
steerage946833steerage
storage8310473storage
stowage1136703stowage
strafe95215983str_afe
strake104017393str_ake
strange85416343strange
stravage1245563stravage
striae65422273stria_e
striate74218953striate
suffrage1554523suffrage
sulfate10311653sulfate
sullage859913sullage
surbase939793surbase
surfable1338443surfable
surfaced1436063surfaced
surfacer1345663surfacer
surfaces1338673surfaces
surge65027693sur__ge
surname937603surname
swage94919563s__wage
syringe11349473syringe
teenage8108053teenage
tentage81010643tentage
ternate7415483ternate
terrace93311843terrace
terrae62915213terra_e
terrane72814233terrane
triage72812893_triage
username1042583username
ventage11109623ventage
verbiage1444553verbiage
verge93419843ver__ge
vorlage1136403vorlage
warfare1336733warfare
warpage1336403warpage
webpage1543133webpage
welfare1335713welfare
wharfage1842213wharfage
wordage1236503wordage
yardage1235733yardage

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272167.31018334.7
3Display Results2162160.0802700.0
 (SQL Overall)1786912167.78022968.0
 
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.