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

148 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
surfaces133867(None) 
surface1238651surface_
surfaced1436061surfaced
surfacer1345661surfacer
surfacers1444321surfacers
furnaces1336052furnaces
outfaces132311392outfaces
resurfaces1543012resurfaces
serfages1238232serfages
subraces12313032subraces
suffices16208182suffices
sulfates11310792sulfates
surbases10310002surbases
surnames1037272surnames
surtaxes1536512surtaxes
airfares1146693airfares
bifaces1448063_bifaces
boraces113716853bor_aces
braces108427773_br_aces
bullaces12299433bullaces
burgages1236483burgages
carfares13310323carfares
catfaces1536963catfaces
clubfaces1841913clubfaces
curacies12311763cur_acies
curares94916853cur_ares
curates95323833cur_ates
currachs1544543currachs
defaces133213403_defaces
dogfaces1554143dogfaces
durances1158683durances
effaces15277273_effaces
enfaces122110913_enfaces
faces106439433___faces
forefaces1747133forefaces
fullfaces1742633fullfaces
furanes103214863fur_anes
furcates1339883furcates
furfures1445663furfures
furnace1235943furnace_
furnaced1443513furnaced
graces94523493_gr_aces
hyraces1537913hyr_aces
lurdanes936063lurdanes
muriates10312083muriates
murices112612283mur_ices
outface123011973outface_
outfaced14219463outfaced
outpaces122411943outpaces
outraces102217863outraces
prefaces15311063prefaces
purfles122511843purf_les
races74943243__r_aces
refaces123216743_refaces
resurface1443273resurface_
resurfaced1642463resurfaced
resurfacer1551973resurfacer
resurfacers1651473resurfacers
rubaces1139313ru_baces
sarapes94617753sar_apes
scrapes116217663scr_apes
seracs84418573ser_ac_s
serapes95218103ser_apes
serfage1138403serfage_
seriates82620673seriates
serrates82617023serrates
services1338573services
solaces93116133s_olaces
sorbates10311103sorbates
sources9312173sour__ces
spaces104722633s__paces
spruces113810503spr_uces
strafes104516003str_afes
strakes114218073str_akes
striates83417083striates
subbases1239063subbases
subduces1397263subduces
subfiles131710723subfiles
subfixes20207493subfixes
subframes1645853subframes
sublates10315003sublates
subrace11313003subrace_
subsales10310123subsales
subspaces1545673subspaces
subsurfaces1852033subsurfaces
sucrases10310253sucrases
suffaris1445083suffaris
suffice15197573suffice_
sufficed17205663sufficed
sufficer16225823sufficer
sufficers17204533sufficers
suffixes21196353suffixes
sufflates1546033sufflates
suffrages1644383suffrages
suffuses1435833suffuses
sulfas9311563sulfa__s
sulfate10311653sulfate_
sulfated1238833sulfated
sulfides1238053sulfides
sulfites1139903sulfites
sulfones1147683sulfones
sullages939973sullages
sumachs14457353su_machs
sumacs105512103su_mac_s
summates122610493summates
sundaes8313093sunda_es
superraces1449863superraces
surahs94515543sur_a_hs
suras55336333sur_a__s
surbase939793surbase_
surbased1136613surbased
surceases1157473surceases
sureties8316583sureties
surfable1338443surfable
surfacing1545643surfacing
surfacings1642453surfacings
surfed103814463surf__ed
surfeits1146223surfeits
surfer93515883surf__er
surfers103614133surf_ers
surfier102613543surf_ier
surfiest112414433surf_iest
surfings12268073surfings
surfmen1235993surf_men
surfs85022543surf___s
surges73924593sur__ges
suricates11311743suricates
surmises10310643surmises
surname937603surname_
surnamed1135113surnamed
surnamer1044883surnamer
surnamers1143803surnamers
surpass938283surpa_ss
surpasses1145533surpasses
surplices1346043surplices
surras65919533surra__s
surtaxed1644133surtaxed
survives1436333survives
terraces102712253terraces
traces85329933_tr_aces
turacos938643tur_acos
unifaces1346393unifaces
unlaces92513623_unlaces
urares64519093_ur_ares
urases63723563_ur_ases
urates65027763_ur_ates
ureases74416723_ureases
warfares1436683warfares

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621487.72018932.9
3Display Results1481480.0632349.2
 (SQL Overall)1786911488.18621828.9
 
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.