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

391 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
orrices912936(None) 
orrice81410161orrice_
orrises71312231orrises
arrises71617582arrises
arrives101311512arrives
carices114220952carices
cornices12713292cornices
corries94026802corri_es
cortices12615012cortices
fornices1369102fornices
lorries74518352lorri_es
morrises10711072morrises
mortices12711562mortices
murices112612282murices
offices1536242offices
oratrices1145832oratrices
ordines83014902ordines
oreides8312022oreides
orgies72316092orgi_es
orifices1346482orifices
oroides8311972oroides
orpines94414792orpines
orris54516552orri__s
prices104524542_prices
rices75536152__rices
trices84826332_trices
varices123313572varices
vortices1369122vortices
worries104117132worri_es
advices13136933advices
aeries64737783aeri_es
amices105018013_amices
apices104916263_apices
arises65233803_arises
armies85123693armi_es
arnicas939543arnicas
arracks1387733arracks
arrases71214543arrases
arris56824683arri__s
arrive91311793arrive_
arrived11127353arrived
arriver10117793arriver
arrivers11137003arrivers
arsines73518813arsines
articles10310243articles
auricles10138333auricles
avarices1337183avarices
barites94322333barites
berimes115216643berimes
berries94423553berri_es
bices95029963__bices
bodices12710593bodices
boraces113716853boraces
borides10515153borides
bornites10310983bornites
bourrides1244823bourrides
braces108427773_braces
braises93818873braises
braizes183112453braizes
bribes105918533_bribes
bricks144614623_bricks
brides94423513_brides
bries74942153_bri_es
brines85028853_brines
brises84927613_brises
bruises93212913bruises
buries84633273buri_es
calices114321693calices
caprices1439893caprices
caribes113715643caribes
caries85147623cari_es
carries94328013carri_es
cerises94722253cerises
cerites94823433cerites
cervices1537133cervices
choices142010613choices
cilices113814023cilices
cimices13279803cimices
codices12512583codices
codrives1437663codrives
coerces11311943coer_ces
coppices1638243coppices
coprinces1547483coprinces
corbies113520123corbi_es
cordites11314623cordites
cornice11612933cornice_
corniced1368593corniced
corniches1666673corniches
cornicles1368243cornicles
corrades111211263corrades
corrects1259573corrects
corridas1177313corridas
corrie83621233corri_e_
corrodes111310333corrodes
cowries124218013cowri_es
cowrites133011593cowrites
crevices1536713crevices
cricks144316053_cricks
cries75438403_cri_es
crimes105521583_crimes
cripes105120873_cripes
crises84529433_crises
cruces105117543_cruces
cruises93514443cruises
culices113713123culices
curies84934023curi_es
curites93919863curites
curricles13105423curricles
curries93723163curri_es
cylices14359283cylices
darics94314113daric_s
deices94119373_deices
derides93420853derides
derives114017813derives
derricks1544433derricks
derries83124623derri_es
derrises93012783derrises
devices133212583devices
dices86434243__dices
dories75232363dori_es
dormice1237133dormice_
dornicks1544403dornicks
dourines9311373dourines
dowries114413983dowri_es
dries64733673_dri_es
drives105117113_drives
durries83817353durri_es
enriches1337263enriches
entices91616333entices
ericas8315463_ericas
ermines9416673ermines
errhines1136413errhines
eyries93816813eyri_es
farces115223323far_ces
farcies125317883farcies
ferries103521083ferri_es
ferrites112312833ferrites
fices106031163__fices
forces114422133for_ces
forcipes1535943forcipes
forgives1535753forgives
formicas1546003formicas
forties104323863forti_es
fraises104215693fraises
fries85535603_fri_es
friges104116483_friges
frises94124273_frises
frites94922483_frites
frizes184015463_frizes
furies95126373furi_es
graces94523493_graces
greiges937733greiges
grides84422363_grides
grimes94619033_grimes
gripes94619873_gripes
gurries83515953gurri_es
harries103525493harri_es
helices12313723helices
herries104025073herri_es
horribles14113973horribles
horrider1236533horrider
horridest1345643horridest
horrifies15146393horrifies
hospices1587633hospices
hurries103919653hurri_es
hyraces1537913hyraces
ibices10398163_ibices
ices66129643___ices
indices103513443indices
irides74519123_irides
irises64221173_irises
jerries143817513jerri_es
joyrides1943853joyrides
juices1549423_juices
juries134120633juri_es
kerries113317913kerri_es
krises105016083_krises
kyries133411373kyri_es
latices9313763latices
lories64933043lori_es
lorises73918593lorises
lyrics11357943lyric_s
malices114316623malices
marines93928013marines
marries93825283marri_es
matrices12312083matrices
merces105720743mer_ces
mercies113817563mercies
merises93421423merises
moraines10314363moraines
morrions1077673morrions
morris83814733morri__s
mortice11711493mortice_
morticed1377163morticed
mortises10713613mortises
murines93718223murines
murries94118673murri_es
myricas1436753myricas
norites74018803norites
notices9312283notices
novices1238223novices
obliges1037143obliges
odorizes1837213odorizes
office1435693office_
officer1534213officer
officers1643803officers
ogives10367913o_gives
ogres65818633ogr__es
ogrisms1036443ogrisms
oldies7314423oldi_es
oleines7313393oleines
olives94313953o_lives
oolites72817843oolites
oorie53026363oori_e_
ophites12310103ophites
opines84820703o_pines
optics102810183optic_s
optimes1148473optimes
oraches124216473oraches
oracles93212423oracles
oranges84215333oranges
orates64328613o_rates
orbier839993orbi_er
orbiest9312413orbi_est
orbited1037733orbited
orbiter937853orbiter
orbiters1036593orbiters
orbits84211443orbi_ts
orcas75918623o_r_cas
orchises1338773orchises
orcins83313433orci_ns
orcs67025433o_r_c_s
ordures856473ordures
oreide7311673oreide_
ores46056683o_r__es
orgic8311823orgic__
orgones81010793orgones
oribis838833o_ribis
oriel54920423o_ri_el
oriels64914623o_riels
orifice1246343orifice_
orioles7412993orioles
orles55326213o_r_les
ornis54616773orni__s
ornithes1136423ornithes
oroide7311703oroide_
orpine83914483orpine_
orpins83614163orpi_ns
orreries8310123orreries
oryxes1674523o_ryxes
oscines9310363oscines
osmics1036463osmic_s
ossicles1054183ossicles
ostriches1446633ostriches
ounces83617773o_unces
ourie54027303ouri_e_
outprices1337623outprices
outraces102217863outraces
outrides92414993outrides
ovaries10312653ovari_es
overprices17108523overprices
overrides131411013overrides
ovines94614343o_vines
oxides14109693o_xides
oximes15107423o_ximes
paries84742513pari_es
parises94827183parises
parries93925843parri_es
perries93226603perri_es
plaices11411143plaices
polices113118053polices
pollices12410753pollices
porgies103017003porgi_es
porkies133416493porki_es
porridges1343913porridges
porticoes1348253porticoes
porticos1238373porticos
praises94121103praises
prances113618773prances
preprices1569263preprices
price93725413_price_
priced115018883_priced
pricer103918293_pricer
pricers113915063_pricers
pricey134412633_pricey
pricks144414263_pricks
prides94324183_prides
pries74339533_pri_es
primes104225263_primes
princes113015143princes
prises84133173_prises
prizes173819813_prizes
pumices1338273pumices
purines94420763purines
pyrites12812203pyrites
races74943243__races
radices102314263radices
raises64826543_raises
rances84625443_rances
recces10614913_recces
reives95723043_reives
reprices122913353reprices
rerises73525883rerises
ribes75530173__ribes
rice64942913__rice_
riced85825543__riced
ricer74726613__ricer
ricers84120993__ricers
riches115022083__riches
ricks115126133__ricks
rides66140813__rides
riles55343643__riles
rimes75634543__rimes
ripes75435773__ripes
rises55244043__rises
rites54442553__rites
rives85336003__rives
saices84221803_saices
scribes113713203scribes
scries85226823scri_es
scrives124414273scrives
series64540973seri_es
serines74229543serines
serries73925353serri_es
services1338573services
shrikes144412393shrikes
shrines104618693shrines
shrives134416173shrives
sices75637273__sices
slices84022853_slices
sluices959073sluices
sordines92414073sordines
sorites73825243sorites
sorrier72313733sorri_er
sorriest8413883sorri_est
sorriness939583sorriness
sorties74126403sorti_es
sources9312173sour_ces
spices104326033_spices
splices113914383splices
sprites94220333sprites
spruces113810503spruces
stricks134310693stricks
strides84520393strides
strifes104716583strifes
strikes114719093strikes
stripes95320573stripes
strives104119373strives
tarries73324263tarri_es
terces83921413ter_ces
terraces102712253terraces
terries73425633terri_es
terrines82117553terrines
thrice114311573thrice_
thrives134611713thrives
torics85118353toric_s
tories65435883tori_es
torrider936173torrider
torridest1045753torridest
torrifies12137033torrifies
tortrixes1644153tortrixes
traces85329933_traces
trances93919643trances
tribes85119023_tribes
trice75127493_trice_
triced95518673_triced
tricep103911073_tricep
triceps11267343_triceps
tricks125319013_tricks
tries55742813_tri_es
trikes105419493_trikes
trines64132563_trines
tripes85324873_tripes
truces84916333_truces
uprises92012733uprises
ureides8311103ureides
urines64724123_urines
utricles1037223utricles
varies94330873vari_es
verites103822263verites
vertices13612283vertices
vices105725533__vices
voices114414013_voices
worried11308693worri_ed
worrier102311683worri_er
worriers11257813worriers
worrited1235743worrited
worrits10258683worri_ts
wricks154610623_wricks
wries85827743_wri_es
writes94420333_writes

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.423422437.4
2DLD Change Limit1340273916.45320769.7
3Display Results3913910.1562506.4
 (SQL Overall)1786913917.03225411.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.