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 “surnaming” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
surnaming124514(None) 
furnacing1543712furnacing
screaming14217822screaming
streaming12239652streaming
surfacing1545642surfacing
surtaxing1784142surtaxing
benaming1339693_benaming
breaming133612513_breaming
burning104215503burn__ing
creaming133413143_creaming
curating11314293cur_ating
dreaming124011063_dreaming
durning93511733durn__ing
framing133014793_fr_aming
furcating1537783furcating
hurrahing1643743hurrahing
hurraying1654313hurraying
journaling1843173journaling
misnaming1447423misnaming
naming93917893___naming
reaming103924013__reaming
renaming11313693_renaming
roaming103215793__roaming
ruinating1039593ruinating
salaaming1265363salaaming
saunaing937013sauna_ing
scramming1634883scramming
scraping133310863scr_aping
screaking16228223screaking
scrumming1654023scrumming
seaming103222113s__eaming
serenading1246093serenading
seriating10916393seriating
serrating10513193serrating
shaming133016743s__haming
signaling1136563signaling
snaking123915303s__naking
snaring83920953s__naring
snawing113612483s__nawing
sorning83116813sorn__ing
spraying14299883spr_aying
spreading1339653spreading
spurning11258663spurn__ing
steaming114013213s_teaming
strafing122111193str_afing
stranding1149653stranding
strawing122411623str_awing
straying122912693str_aying
streaking142010313streaking
streamings13185153streamings
striating10914193striating
strumming1454413strumming
sublating12310983sublating
subliming1446533subliming
subsuming1444273subsuming
subwaying1843873subwaying
sugaring1039053su_garing
sulfating1338063sulfating
summating1437943summating
summing122912383su__mming
sunning83715673su_n_ning
supinating1357833supinating
surceasing1345073surceasing
surfacings1642443surfacings
surfing112914483sur__fing
surging93115433sur__ging
surmising1247683surmising
surname937603surnam__e
surnamed1135113surnam_ed
surnamer1044883surnam_er
surnamers1143803surnamers
surnames1037273surnam_es
surpassing1343833surpassing
surveying1644963surveying
surviving1644163surviving
turning83713183turn__ing
unaging9510933_u_naging
unarming1138623_u_narming
urinating10310653_urinating

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641798.09318366.6
3Display Results79790.0461717.4
 (SQL Overall)178691798.31221498.0
 
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.