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

153 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
surname93760(None) 
surnamed1135111surnamed
surnamer1044881surnamer
surnames1037271surnames
furnace1235942furnace
surbase939792surbase
surface1238652surface
surnamers1143802surnamers
username1042582username
arame75026623_ar_ame
aurae54128113aur_a_e
aurate64426473aur_ate
aureate72515283aureate
bename103316073_bename
burgage1136633burgage
burnable1237263burnable
burnie83715413burn_ie
bursae84515603bursa_e
bursate94111203bursate
byname13256363_byname
carnage10311743carnage
curare84916953cur_are
curate85226243cur_ate
curiae84518373curia_e
curtate9312643curtate
dunam8313733du_nam_
dunams937833du_nams
dunnage9175213dunnage
duramen1096903dur_amen
durance1059113durance
forename1347853forename
frame105821803_fr_ame
furane94015493fur_ane
furcate12310453furcate
furnaced1443513furnaced
furnaces1336053furnaces
guanase836213guanase
gurnard944773gurnard
jobname1842903jobname
lunate6316043lu_nate
lurdane835983lurdane
misname11119483misname
muriate9313363muriate
name65637413___name
ornate6315133_ornate
penname11328553penname
prename11412643prename
quinate16511573quinate
rename82718813_rename
ruinate7312833ruinate
same65245643s___ame
sarape84817573sar_ape
scram910621613scr_am_
scrams105216623scr_ams
scrape105917573scr_ape
scream104814243scream_
screamed13277593screamed
screamer12267873screamer
screams114810613screams
senate63725143s_enate
serape84818413ser_ape
serenade9218343serenade
serenate81914873serenate
serfage1138403serfage
seriate73722473seriate
serrate73017533serrate
sesame8311013s_esame
shame105726703s__hame
signage937773signage
snake94821113s__nake
snare54429983s__nare
sorbate9311733sorbate
spinage10289653spinage
spinate93114813spinate
strafe95215973str_afe
strake104017393str_ake
strange85416343strange
stream84717283stream_
streamed11258903streamed
streamer10239503streamer
streams94713373streams
streamy12509483streamy
striae65422273stria_e
striate74218953striate
strumae9368093strumae
suave83519873su__ave
subbase1139323subbase
subframe1546333subframe
sublate9315363sublate
sublime11310353sublime
subrace11313003subrace
subsale9310543subsale
subsume1146713subsume
sucrase9310343sucrase
sulcate9314423sulcate
sulfate10311653sulfate
sullage859913sullage
summae103911013summa_e
summate113611663summate
sundae7312873su_ndae
sunlamp1144163sunlamp
sunna55016063sunna__
sunnah9369353sunna_h
sunnahs10326593sunnahs
sunnas63914563sunna_s
sunray9310123sunra_y
sunrays1037083sunrays
sunrise7310813sunrise
supernate11313273supernate
supinate10310313supinate
supreme1137893supreme
sura45740293sur_a__
surah86823253sur_a_h
surahs94515543sur_ahs
sural55931263sur_a_l
suras55336323sur_a_s
surbased1136613surbased
surbases10310003surbases
surcease1086883surcease
sure45447413sur___e
surfable1338443surfable
surfaced1436063surfaced
surfacer1345663surfacer
surfaces1338673surfaces
surfman1236203surfman
surfmen1235993sur_fmen
surge65027693sur__ge
suricate10312613suricate
surimi839103sur_imi
surmise9311083surmise
surnaming1245143surnaming
surpass938283surpass
surra55521343surra__
surras65919533surra_s
surtax1337843surta_x
surtaxed1644133surtaxed
surtaxes1536513surtaxes
survive1335933survive
ternate7415483ternate
tsunami943013tsu_nami
tunnage8166373tunnage
turnable1037853turnable
ulnae55214573_ulna_e
unnamed102410273_unnamed
untame82513603_untame
urare56322553_ur_are
urase54624683_ur_ase
urate55432163_ur_ate
urbane82211383_urbane
urease64516993_urease
urinate7315363_urinate
ursae55214453_ursa_e
usernames1142373usernames

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.1401276364.3
2DLD Change Limit1340271537.66017497.0
3Display Results1531530.0463326.1
 (SQL Overall)1786911537.84622774.8
 
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.