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

234 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
refence1231223(None) 
defence1339891defence
refenced1438991refenced
refences13311841refences
credence1387822credence
defenced1537202defenced
defences1439632defences
defense1137502defense
fence105319912__fence
offence1545352offence
presence122213512presence
pretence122312122pretence
recency1438632recency
reface113616352ref_ace
refect114319332refe_ct
referee101615752referee
reference14810092reference
refine95225692refin_e
refluence1445852refluence
regency1337362regency
retene69224272reten_e
revenge1138572revenge
revenue1039532revenue
unfence1239192unfence
absence1137713absence
bedunce1235683bedunce
cadence1239063cadence
credences1498143credences
decency1537453decency
deface123113863def_ace
defect124816173defe_ct
defend113910493defen_d
defended1437223defended
defender1337293defender
defends12358773defends
defensed1336223defensed
defenses1237913defenses
deference1578493deference
defiance1477633defiance
define104718143defin_e
deforce13267243deforce
defunct1345773defunct
detente83313603detente
efface14366673_efface
essence947673essence
evince1137763_evince
faience1237513faience
fenced124412713__fenced
fencer114613533__fencer
fences114617113__fences
frequence2344803frequence
greenie8310123gre_enie
hence104920043__hence
ketene106613003keten_e
lenience1048333lenience
licence11119363licence
lucence11148003lucence
mergence13137943mergence
offences1645023offences
offense1343683offense
outfence1356973outfence
penance11313443penance
pence94924453__pence
potence11711363potence
preface14510923pref_ace
prefect141011073prefe_ct
preference1776983preference
prepense12238943prepense
presences132113793presences
pretences132312613pretences
pretense10199823pretense
prudence1346333prudence
rance75028513r__ance
rebec94416543rebe_c_
rebeck14419913rebe_ck
rebecs103913673rebe_cs
recane83022873recan_e
recce9514563r__ecce
recede95515533rece_de
receive1239733receive
recencies13312253recencies
recent83630853recen_t
recenter102715443recenter
recreance1346993recreance
redenied10511283redenied
redenies9615713redenies
redeny102712733reden_y
redeye103811793rede_ye
redneck1445113redneck
redolence1256763redolence
redone74820053redon_e
reduce9713253re_duce
reenact9413003re_enact
reenter73217793re_enter
reeve84121323re_e_ve
refaced133713573ref_aced
refaces123216743ref_aces
refected142311663refected
refects124012743refects
refed93921923refe__d
refeed104717623refe_ed
refeeds11368973refeeds
refeel93913243refe_el
refeels10379693refeels
refel84920813refe__l
refell94214443refe_ll
refelled122810163refelled
refels94618053refe_ls
refelt94521423refe_lt
refencing15188853refencing
refer84822143refe__r
refereed12149693refereed
referees111310413referees
referenced1676863referenced
references1589353references
referred1297833referred
referrer11136053referrer
refers93921083refe_rs
refile95122373ref_ile
refinance14117643refinance
refind104717073refin_d
refinds114512123refinds
refined114720003refined
refiner105316913refiner
refines105426343refines
refire95419473ref_ire
reflate103516263reflate
reflect123913713reflect
refluences1545513refluences
reforge11259033reforge
refract121311603refract
reframe1239393reframe
refreeze2063263refreeze
refroze1956223refroze
refuge105312613ref_uge
refugee115310943refugee
refulgence1653613refulgence
refund104810303refun_d
refunded1336953refunded
refunder1236503refunder
refunds11448623refunds
refuse94817513ref_use
refute95515703ref_ute
regencies1249283regencies
regent74127673regen_t
regents83416543regents
reginae84713453reginae
rehinge1148503rehinge
reject154116283reje_ct
rejoice16287453rejoice
relace83122153re_lace
release7312763release
relend76116453relen_d
relends84013253relends
relent64431853relen_t
relented92614943relented
relents74018503relents
relevance14146443relevance
releve95116403rele_ve
reliance10310473reliance
reline65434353relin_e
remanence1346713remanence
remend95216553remen_d
remended123010393remended
remends105013033remends
remerge10148923remerge
renege72713763rene_ge
renitence1149053renitence
renounce1047403renounce
rente54733783r__ente
repent84728873repen_t
repented112614983repented
repenter102813863repenter
repents93717623repents
repine85627813repin_e
replace113214283replace
reprice113212833reprice
reremice1246023reremice
rerent63832453reren_t
rerented92516163rerented
rerents73319423rerents
resect84424703rese_ct
resee54336333rese__e
reseize1639553reseize
resend75016773resen_d
resends83513713resends
resent63833623resen_t
resented92716963resented
resents74221223resents
reserve101011203reserve
residence1268903residence
respace11310913respace
reteach1237413reteach
retenes76324623retenes
reticence1347623reticence
retinae75517333retinae
retine66237333retin_e
retinue75414843retinue
retrace91417343retrace
retrench1346283retrench
retune69121953retun_e
revanche1645003revanche
revenged1337553revenged
revenger1237303revenger
revenges1238983revenges
revenued1237223revenued
revenuer1136893revenuer
revenues1138663revenues
revere94621253reve_re
reverence14710163reverence
reverie103615163reverie
reverse103913743reverse
revoice12319183revoice
reweave1336773reweave
rexine134719443rexin_e
rezone153814783rezon_e
romance11311083romance
science1138783science
seance83716693se_ance
sentence1099863sentence
sequence1946903sequence
serene63522353seren_e
silence9310213silence
spence103813793_spence
tendence1148523tendence
tenpence1246403tenpence
thence112010843_thence
unfenced1437733unfenced
unfences1337933unfences
valence1268773valence
venene92912523venen_e
vergence14128273vergence
weenie92612023we_enie
whence14187923_whence

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.403443402.0
2DLD Change Limit1340272347.23618522.2
3Display Results2342340.0932516.1
 (SQL Overall)1786912347.73223110.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.