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

227 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
refences1331184(None) 
defences1439631defences
refence12312231refence_
refenced1438991refenced
credences1498142credences
defence1339892defence_
defenced1537202defenced
defenses1237912defenses
fences114617112__fences
offences1645022offences
presences132113792presences
pretences132312612pretences
recencies13312252recencies
redenies9615712redenies
refaces123216742ref_aces
refects124012742refe_cts
referees111310412referees
references1589352references
refines105426342refin_es
refluences1545512refluences
regencies1249282regencies
retenes76324622reten_es
revenges1238982revenges
revenues1138662revenues
unfences1337932unfences
absences1247673absences
bedunces1345513bedunces
cadences1338473cadences
credence1387823credence_
decencies1448943decencies
defaces133213403def_aces
defects134511523defe_cts
defended1437223defended
defender1337293defender
defenders1436363defenders
defends12358773defen_ds
defense1137503defense_
defensed1336223defensed
deferences1677873deferences
defiances1557033defiances
defines114118683defin_es
deforces14248403deforces
detentes92712873detentes
effaces15277273_effaces
essences1047563essences
evinces1237803_evinces
faiences1337043faiences
feces105625363__fe_ces
fence105319913__fence_
fenced124412713__fenced
fencer114613533__fencer
fencers123810623__fencers
frequences2444933frequences
greenies9312673gre_enies
ketenes114813503keten_es
leniences1148143leniences
licences12129323licences
lucences12137313lucences
mergences14137553mergences
offence1545353offence_
offenses1443833offenses
outfences1456463outfences
penances12312443penances
potences12710693potences
prefaces15311063pref_aces
prefects1598133prefe_cts
preferences1876183preferences
presence122213513presence_
pretence122312123pretence_
pretenses112210593pretenses
prudences1446683prudences
rances84625443r__ances
rebecks15288013rebe_cks
rebecs103913673rebe_c_s
recanes93222263recan_es
recces10614913r__ecces
recedes102816063rece_des
receives1339743receives
recency1438633recenc_y
recenter102715443recenter
recentest11410283recentest
recesses10312323recesses
recreances1446503recreances
redefies12710163redefies
redenied10511283redenied
redeyes112910973rede_yes
rednecks1544013rednecks
redolences1376803redolences
reduces10513343re_duces
reenacts1036993re_enacts
reenter73217793re_enter
reenters82915303re_enters
reeves94721493re_e_ves
reface113616353ref_ace_
refaced133713573ref_aced
refect114319333refe_c_t
refected142311663refected
refeed104717623refe__ed
refeeds11368973refe_eds
refeel93913243refe__el
refeels10379693refe_els
refelled122810163refelled
refels94618053refe__ls
refencing15188853refencing
referee101615753refe_ree
refereed12149693refereed
reference14810093reference_
referenced1676863referenced
referred1297833referred
referrer11136053referrer
referrers12125373referrers
refers93921083refe__rs
refiles104122423ref_iles
refinances15107133refinances
refinds114512123refin_ds
refine95225693refin_e_
refined114720003refin_ed
refiner105316913refin_er
refiners114713313refiners
refires104820313ref_ires
refixes174813173ref_ixes
reflates113115663reflates
reflects13288873reflects
reflexes1865923reflexes
reflies104418533ref_lies
refluence1445853refluence_
refluxes1855183refluxes
refocus1236973ref_ocus
reforges12249333reforges
refracts13137383refracts
reframes1338993reframes
refreezes2153443refreezes
refreshes1595953refreshes
refries104419733ref_ries
refugees12476403refugees
refuges115413373ref_uges
refulgences1753353refulgences
refunded1336953refunded
refunder1236503refunder
refunders1334973refunders
refunds11448623refun_ds
refuses104918553ref_uses
refutes104515723ref_utes
regency1337363regenc_y
regents83416543regen_ts
rehinges1248403rehinges
rejects163910693reje_cts
rejoices17287663rejoices
relaces93420883re_laces
releases8313343releases
relends84013253relen_ds
relented92614943relented
relents74018503relen_ts
relevances1596113relevances
releves103914973rele_ves
reliances1139623reliances
relines75331323relin_es
remanences1446623remanences
remedies11310553remedies
remended123010393remended
remends105013033remen_ds
remerges111110203remerges
reneges82513593rene_ges
renitences1248443renitences
renounces1147543renounces
rentes65431193r__entes
repented112614983repented
repenter102813863repenter
repenters112511553repenters
repents93717623repen_ts
repines94927383repin_es
replaces123114123replaces
reprices122913353reprices
rerented92516163rerented
rerents73319423reren_ts
resects94115593rese_cts
resees63827483rese__es
reseizes1759853reseizes
resends83513713resen_ds
resented92716963resented
resents74221223resen_ts
reserves111011983reserves
residences1368233residences
respaces12311043respaces
reteaches1437123reteaches
retene69224273reten_e_
reticences1447453reticences
retines75134673retin_es
retinues85113153retinues
retraces101417273retraces
retrenches1545903retrenches
retunes76918403retun_es
revanches1746253revanches
revenge1138573revenge_
revenged1337553revenged
revenger1237303revenger
revengers1336413revengers
revenue1039533revenue_
revenued1237223revenued
revenuer1136893revenuer
revenuers1235983revenuers
reverences1579173reverences
reveres103621343reve_res
reveries112518513reveries
reverses112513513reverses
revoices13278993revoices
reweaves1436603reweaves
rexines144719153rexin_es
rezeroes1737143rezeroes
rezones163213943rezon_es
rifeness1138583rifeness
romances12310793romances
sciences1238773sciences
seances93015343se_ances
sentences11610303sentences
sequences2067013sequences
serenes73222903seren_es
silences10310073silences
spences113413923_spences
tendences1248083tendences
tenpences1346543tenpences
unfence1239193unfence_
unfenced1437733unfenced
valences1388513valences
venenes102712133venen_es
vergences15128063vergences
weenies102915093we_enies

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.1731032896.0
2DLD Change Limit1461622277.93618417.6
3Display Results2272270.1102063.6
 (SQL Overall)1786912278.21921741.2
 
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.