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

284 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
respace1131091(None) 
respaced1338501respaced
respaces12311041respaces
respade1039571respade
bespake15436962bespake
reface113616352re_face
relace83122152re_lace
repack142412162re_pack
repave114813872re_pave
replace113214282replace
resale64025542res_ale
rescale93215472rescale
reshape1249042reshape
reshave1338602reshave
reslate73520592reslate
respaded1238132respaded
respades1139852respades
respect11412032respect
respire9411542respire
respite9513032respite
resplice1237252resplice
respoke134311282respoke
restack1339432restack
restage83316182restage
restate73824872restate
retrace91417342retrace
space95325672__space
aerospace1343743aerospace
airspace1244653airspace
amesace1147733ames_ace
apace94718383__apace
auspice1136523auspice
beshame1447483beshame
bespoke15468113bespoke
creepage1344343creepage
crispate1246913crispate
cuspate1138233cuspate
deface123113863de_face
despair1045463despair
despatch1643223despatch
despise1038683despise
despite10410123despite
displace1348653displace
dressage1044253dressage
efface14366673_efface
empale102611263_empale
emplace1338263_emplace
enface112510353_enface
enlace82213233_enlace
epact94921533_e_pact
escape103811663_escape
estate64719763_estate
forespake18105233forespake
gestate83614073gestate
headspace1752783headspace
hospice14117053hospice
menace103216943me_nace
message1037833message
midspace1543953midspace
mispage12310523mispage
misplace1437553misplace
misspace1446523misspace
outpace112613023outpace
pace86345773___pace
peace95026083pe__ace
pesade9311103pes_ade
preface14510923pre_face
prepack1757643pre_pack
prepare111913623pre_pare
prepave14228873pre_pave
preplace1488973preplace
prepuce1337833pre_puce
prerace11414123pre_race
presage10312293pres_age
presale9416353pres_ale
presence122213503presence
preshape1537533preshape
preslice1258603preslice
race66746263r___ace
rampage1237453rampage
reach105123883re__ach
react74634333re__act
reapable12311393reapable
reave84528023re__ave
reawake14457893reawake
rebate84424103re_bate
recane83022873re_cane
recce9514563re__cce
reclame11411063reclame
recrate92621643recrate
redact9419043re_dact
redate74124683re_date
rediae74221993redia_e
reduce9713253re_duce
redware1139353redware
reenact9413003reenact
refaced133713573re_faced
refaces123216743re_faces
refence12312223refence
reflate103516263reflate
refract121311603refract
reframe1239393reframe
regale74821453re_gale
regave104713383re_gave
reggae858953regga_e
reglaze1747223reglaze
regrade92612033regrade
regrate82618653regrate
reimage1037913reimage
rejoice16287453rejoice
relaced103517213re_laced
relaces93420883re_laces
relapse947703relapse
relate64033633re_late
release7312763release
reliance10310473reliance
remade94316983re_made
remake124016113re_make
remate84428683re_mate
rename82718813re_name
rennase738713rennase
repacked17188743re_packed
repacks15269543re_packs
repaid94716323re_paid
repair84011463re_pair
repand95316063re_pand
repanel939963re_panel
repaper11310023re_paper
repark123511713re_park
repass84114703re_pass
repast83520633re_past
repatch1435843re_patch
repaved133311133re_paved
repaves123513653re_paves
repay104818453re_pa_y
repays113813973re_pays
repine85627813re_pine
replaced133211393replaced
replacer12279743replacer
replaces123114123replaces
replate93420053replate
repose84121413re_pose
reprice113212833reprice
repute84716093re_pute
rerack122513163re_rack
resaid74517083res_aid
resail64418733res_ail
resales74724903res_ales
resat55139683res_a_t
resaw84117253res_a_w
resawed113111183res_awed
resawn9399953res_awn
resaws93713513res_aws
resay85320543res_a_y
resays93714153res_ays
rescaled113311303rescaled
rescales103414563rescales
rescore95616193rescore
rescue8313003res_cue
reseal64819643resea_l
resealed92713953resealed
reseals73917663reseals
research1344553research
reseat64131493resea_t
reseated93220263reseated
reseats74319583reseats
reseau64216213resea_u
reseaus74012153reseaus
reseaux14326233reseaux
resect84424703res_ect
resee54336333res__ee
reseize1639553reseize
reserve101011203reserve
reshaped1437203reshaped
reshaper1336913reshaper
reshapes1338803reshapes
reshaved1536873reshaved
reshaven1435193reshaven
reshaves1438733reshaves
reshine102816943reshine
reshoe92816483res_hoe
reshone102414163reshone
reside74224933res_ide
residue8689863residue
resile64627673res_ile
resinate8316773resinate
resite64128453res_ite
resize154117723res_ize
reslated93517523reslated
reslates83619493reslates
resoak10311093resoa_k
resoaked1337943resoaked
resoaks1148973resoaks
resole64624183res_ole
resolve103910983resolve
resonance1147623resonance
resonate8513513resonate
resource1046313resource
respacing1438893respacing
respeak1335933respeak
respeaks1434953respeaks
respected1438493respected
respecter1347443respecter
respects1247703respects
respell947023respell
respelt9312143respelt
respired1148993respired
respires10311903respires
respited11410813respited
respites10513243respites
respliced1445533respliced
resplices1336623resplices
resplit9310373resplit
respoken14506923respoken
respond1039113respond
response1037743response
respool937633respool
respot83117633resp_ot
respots92912763respots
resprang11175843resprang
respray1236503respray
resprayed1544353resprayed
resprays1344713resprays
restable101618433restable
restacked1636483restacked
restacks1438093restacks
restaff1339003restaff
restaged103011853restaged
restages92815763restages
restamp1146483restamp
restart7320033restart
restated93120173restated
restates83423413restates
restive10315933restive
restock1338673restock
restoke116113903restoke
restore75822973restore
restyle1038763restyle
resume8313783res_ume
resupine1037543resupine
resurface1443273resurface
resurge839073resurge
retack122612823re_tack
retake104718533re_take
retape83917683re_tape
reteach1237413reteach
retraced111413023retraced
retracer101411883retracer
retraces101417263retraces
retrack131310723retrack
retract91318113retract
reuptake1443463reuptake
revoice12319183revoice
rewake135218463re_wake
reweave1336773reweave
rosacea944713ros_acea
roseate7613453roseate
rubace10310173r_ubace
seepage1037543seepage
sesame8311013ses_ame
spaced114517253__spaced
spacer104917793__spacer
spaces104722633__spaces
spacey136212533__spacey
spacy125415623__spacy
spade84423323__spade
spae65034323__spa_e
spake114322743__spake
spale74929213__spale
spare75135563__spare
spate74731583__spate
spice95528813__spice
subspace1445683subspace
tenace82715693te_nace
terrace93311833terrace
testacy1235963testacy
testae64216253testa_e
testate73916233testate
trespass1043383trespass
vendace1357363vendace
vesicae12177703vesicae
vespine1237903vespine
webpage1543133webpage
workspace2052133workspace

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.1561145455.1
2DLD Change Limit1340272846.86019537.5
3Display Results2842840.1102581.8
 (SQL Overall)1786912847.12625075.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.