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

100 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
seafaring134596(None) 
seafarings1442781seafarings
safariing1344552s_afariing
searing83330922se__aring
bearing103624773be__aring
beavering1538703beavering
beggaring1435183beggaring
bewaring14279493be_waring
cellaring1238533cellaring
deafening1476273deafening
deairing10311893dea_iring
declaring1339573declaring
defacing15238683de_facing
defaming15238463de_faming
earing75235483_e__aring
earring83519013_ea_rring
effacing1744463_effacing
enfacing1467293_enfacing
faring105231283___faring
fearing113520033fe__aring
featuring1337323featuring
gearing92818843ge__aring
hearing113324163he__aring
leafing113313583leaf__ing
measuring1236123measuring
nearing83020333ne__aring
rearing83128783re__aring
reawaking17216073reawaking
refacing142512813re_facing
refiring123513923re_firing
regearing112211413regearing
rehearing132211763rehearing
retearing102214253retearing
rewearing132310703rewearing
sabering112113743s_abering
sabring102614843s_a_bring
sacring103115983s_a_cring
safari91110223s_afari__
safaried1236253s_afaried
safaris101110663s_afari_s
saggaring12236243saggaring
salarying1336073s_alarying
savaging1356673s_avaging
savarin10310003s_avarin_
savarins1139893s_avarins
savoring1269483s_avoring
scaring103421973s__caring
scarring112511513sca_rring
seafarer1144843seafar_er
seafarers1244143seafarers
seafront1148023seaf_ront
seagoing1038193sea_going
sealing83528563se__aling
seaming103222113se__aming
searching1538343searching
seasoning1037413seasoning
seating84130683se__ating
seatrain847923seatrain_
seatrains947603seatrains
sectoring1239583sectoring
securing11310413se_curing
sedating103014113se_dating
seesawing1343653seesawing
selfing112911623self__ing
sensating1039253sensating
separating1348643separating
seriating10916403seriating
sering74731813se___ring
serrating10513213serrating
severing122013853se_vering
sewering122411093se_wering
shafting15278683shaf_ting
sharing113723243s__haring
sheafing15329483sheaf__ing
shearing123915903s_hearing
slavering1338723slavering
smearing113511753s_mearing
snaffling1643763snaffling
snafuing1235083snaf_uing
snaring83920953s__naring
soaring83521893s__oaring
sparing104823873s__paring
sparring113112223spa_rring
spearing113216103s_pearing
squaring18158633s_quaring
staffing15247493staf_fing
staring84527053s__taring
starring92312953sta_rring
steamering1345443steamering
suffering1637293suffering
sugaring1039053s_ugaring
sulfating1338063sulfating
sulfuring1345783sulfuring
surfacing1545643surfacing
swearing123711443s_wearing
tearing84021493te__aring
telfering1336253telfering
wafering15208893_wafering
wayfaring1942513wayfaring
wearing113318863we__aring

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.453394461.4
2DLD Change Limit1486411007.48619855.9
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.98522378.3
 
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.