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

184 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
sferics123613(None) 
clerics1149332clerics
ferias95020392_ferias
scenics1137772scenics
seracs84418572s_eracs
series64540972s_eries
serifs94017052s_erifs
serins64029672s_erins
sherifs13299682sherifs
spherics1537072spherics
steric8317062steric_
aeries64737783_aeries
afrits9311903af_rits
agarics10319943agarics
aperies9423203aperies
ascetics1247073ascetics
asterias8317013asterias
cercis104614493_cercis
cerias83321983_cerias
ceric94023093_ceric_
chemics16349583chemics
cleric10612133cleric_
clerids1049093clerids
cretics112911653cretics
darics94314113_darics
emeries91620023emeries
emetics11610723emetics
enterics10312853enterics
epics95014283__epics
erica7316543__erica
ericas8315463__ericas
fabrics1436093fabrics
faeries104118993faeries
felids103111623_felids
ferals94216643_ferals
feres86038183_fer_es
feria85922713_feri_a
feriae95618603_feriae
ferial94621253_ferial
ferine96422583_ferine
ferity122813343_ferity
ferlies103216693_ferlies
fermis114313503_fermis
ferns85220083_fer_ns
ferric1139993_ferric_
ferries103521083_ferries
fetich1479693_fetich
flics105418363_f_lics
fluerics1345393fluerics
fries85535603_f_ries
frigs96019273_f_rigs
frits86129103_f_rits
furies95126373_furies
generics11118793generics
herdics13249523_herdics
heroics122912003_heroics
hysterics1746053hysterics
icterics1247053icterics
irenics937833irenics
jerids142810943_jerids
luetics937323luetics
lyrics11357943_lyrics
medics114115353_medics
mercs96020453_mer_cs
merits8320873_merits
metrics11312363metrics
numerics1266283numerics
peeries93623023peeries
perils84121853_perils
peris75537073_peri_s
poetics11312073poetics
pterins9812993pterins
queries16315873queries
refries104419733refries
relics84517903_relics
rerigs74014793_rerigs
rubrics1177093rubrics
safaris101110663safari_s
safeties1139163safeties
sarins63932623s_arins
saris54544953s_ari_s
sauries72821623sauries
scenic10510513scenic_
sceptics1455663sceptics
schriks16185743schriks
scries85226823s_cries
scrims104615933s_crims
scrips105316033s_crips
secs65033893s_e__cs
seeress7311573seeress
seers55136383seer__s
seifs85019333s_e_ifs
seis45542393s_e_i_s
semis74623533s_emi_s
sepias83616103s_epias
sepic94617053s_epic_
septics112810433septics
serac75925203s_erac_
serails73318363s_erails
serais64326133s_erais
sereins73716123s_ereins
seres55448893s_er_es
serfs84922013s_er_fs
serges74225973s_erges
serial64625863s_erial
serials73919743s_erials
sericin9312843s_ericin
sericins10312463s_ericins
serif84132133s_eri_f
serin55434443s_eri_n
serine65432673s_erine
serines74229543s_erines
sering74731813s_ering
serious73616283s_erious
serous65023563s_erous
serows96016393s_erows
serries73925353serries
sers45746653s_er__s
serums83916303s_erums
serves94423653s_erves
service1239093s_ervice
services1338573s_ervices
servos93812723s_ervos
sharias102516003sharias
sharifs13279903sharifs
sheiks132510013she_iks
sherds105614723sher_ds
sherif122915243sheri_f
sheriff16287693sheriff
sheriffs17253923sheriffs
sherpas1238093sherpas
sherries111812893sherries
sherris10168803sherris
shris84221453s_hri_s
sics65234093s___ics
sierras737863sierras
silvics1235563silvics
skeins103911903ske_ins
skeptics1653863skeptics
skerries12168673skerries
smerks12449713smer_ks
sonics84315633s_onics
sparids103512123sparids
species11314133species
specs96916673spe__cs
speils84116223spe_ils
speirs85013233spe_irs
speiss84311643spe_iss
spermic1338523spermic_
sperms102512603sper_ms
spheric14510073spheric_
spics94123243s__pics
spirits94112623spirits
sprigs94814773s_prigs
sprits85122533s_prits
sris45434153s__ri_s
statics93314533statics
stearic939423stearic_
stearins8312143stearins
steins64818343ste_ins
stelic8313083stelic_
stereos74314973stereos
steres63929533ster_es
sterical10311253sterical
sterile7316603sterile
sterns64616763ster_ns
steroids9911443steroids
sterols7313443sterols
stoics8311113s_toics
stories7324273stories
strick124813203s_trick
stricks134310693s_tricks
strict84821043s_trict
strips85719653s_trips
suberic11312213suberic_
suberins10315093suberins
suers55128483suer__s
swerves1377533swerves
syndics1335703syndics
theriacs1336543theriacs
torics85118353_torics
veeries102916893veeries
vitrics12198553vitrics
xeric144315663_xeric_

Search took 7 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.406440125.6
2DLD Change Limit1340271845.78023188.1
3Display Results1841840.0632920.6
 (SQL Overall)1786911846.24928595.1
 
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.