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 “surface” 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
surface123865(None) 
surfaced1436061surfaced
surfacer1345661surfacer
surfaces1338671surfaces
furnace1235942furnace
outface123011972outface
resurface1443272resurface
serfage1138402serfage
subrace11313002subrace
suffice15197572suffice
sulfate10311652sulfate
surbase939792surbase
surfable1338442surfable
surfacers1444322surfacers
surname937602surname
airfare1047243airfare
aurae54128113aur_a_e
aurate64426473aur_ate
aureate72515283aureate
biface1358103_biface
brace95629273_br_ace
bullace113410673bullace
burgage1136633burgage
bursae84515603bursa_e
bursate94111203bursate
carfare12310073carfare
catface1436763catface
clubface1741973clubface
curacy1339593cur_acy
curare84916953cur_are
curate85226243cur_ate
curiae84518373curia_e
currach1446453currach
curtate9312643curtate
deface123113863_deface
dogface1454053dogface
durance1059113durance
efface14366673_efface
enface112510353_enface
face96140123___face
foreface1647113foreface
fullface1642553fullface
furane94015493fur_ane
furcate12310453furcate
furnaced1443513furnaced
furnaces1336053furnaces
grace85124543_gr_ace
lurdane835983lurdane
muriate9313363muriate
outfaced14219463outfaced
outfaces132311393outfaces
outpace112613023outpace
outrace92418553outrace
preface14510923preface
purfle112511183purf_le
race66746263__r_ace
reface113616353_reface
resurfaced1642463resurfaced
resurfacer1551973resurfacer
resurfaces1543013resurfaces
rubace10310173ru_bace
sarape84817573sar_ape
scrape105917573scr_ape
serac75925203ser_ac_
seracs84418573ser_acs
serape84818413ser_ape
serfages1238233serfages
seriate73722473seriate
serrate73017543serrate
service1239093service
solace83415823s_olace
sorbate9311733sorbate
source8410673sour__ce
space95325673s__pace
spruce103910873spr_uce
strafe95215983str_afe
strake104017393str_ake
striae65422273stria_e
striate74218953striate
suave83519873su__ave
subbase1139323subbase
subduce12106983subduce
subfile122010503subfile
subframe1546333subframe
sublate9315363sublate
subraces12313033subraces
subsale9310543subsale
subspace1445683subspace
subsurface1752163subsurface
sucrase9310343sucrase
suffari1345503suffari
sufficed17205663sufficed
sufficer16225823sufficer
suffices16208183suffices
sufflate1456183sufflate
suffrage1554523suffrage
suffuse1335443suffuse
sulcate9314423sulcate
sulfa8313923sulfa__
sulfas9311563sulfa_s
sulfated1238833sulfated
sulfates11310793sulfates
sulfide1138103sulfide
sulfite10310473sulfite
sulfone1037483sulfone
sullage859913sullage
sumac99514883su_mac_
sumach135310113su_mach
sumacs105512103su_macs
summae103911013summa_e
summate113611663summate
sunback1548153sunback
sundae7312873sunda_e
sunfast1038503sunfast
superrace1349483superrace
sura45740293sur_a__
surah86823253sur_a_h
surahs94515543sur_ahs
sural55931263sur_a_l
suras55336333sur_a_s
surbased1136613surbased
surbases10310003surbases
surcease1086883surcease
sure45447413sur___e
surefire1145213surefire
surf76039313surf___
surfacing1545643surfacing
surfed103814463surf_ed
surfeit10310343surfeit
surfer93515883surf_er
surfers103614133surfers
surfier102613543surfier
surfing112914483surfing
surflike1535933surflike
surfman1236203surfman
surfmen1235993surfmen
surfs85022543surf__s
surfside1244853surfside
surfy115319473surf__y
surge65027693sur__ge
suricate10312613suricate
surmise9311083surmise
surnamed1135113surnamed
surnamer1044883surnamer
surnames1037273surnames
surpass938283surpass
surplice1246203surplice
surra55521343surra__
surras65919533surra_s
surtax1337843surta_x
surtaxed1644133surtaxed
surtaxes1536513surtaxes
survive1335933survive
terrace93311843terrace
trace75829613_tr_ace
turaco839453tur_aco
uniface1236953uniface
unlace82215173_unlace
urare56322553_ur_are
urase54624693_ur_ase
urate55432163_ur_ate
urbane82211383_urbane
urease64516993_urease
ursae55214453_ursa_e
warfare1336733warfare

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.423422437.4
2DLD Change Limit1340271656.90619407.3
3Display Results1651650.0632619.0
 (SQL Overall)1786911657.39224173.6
 
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.