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

235 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
orisha93677(None) 
orishas1036471orishas
arista6415292arista
crissa837622crissa
crista8311802crista
geisha1035212geisha
ogrish1039262ogrish_
orison6411662orison
poisha1135722poisha
rishi8311252_rishi
trishaw1344752trishaw
wisha114910852_wisha
aorist64827873aoris_t
aorists74215833aorists
apish105116633apish_
aria46245423ari__a
aright103817663aright
arise56436433aris_e
arisen65316793arisen
arises65233803arises
aristae7312533aristae
aristas7413523aristas
aristo6414033aristo
barista9310813barista
boarish123911913boarish_
boorish123712593boorish_
borsht11813503bor_sht
boyish142911233boyish_
brash106221563brash_
brashy145210593brashy
bright124215923bright
bris65539613bris__
brises84927613brises
brisk115615983bris_k
brisks124611403brisks
briss75824273bris_s
brith104924373brith_
briths115113863briths
britska13132883britska
brush105917473brush_
brushy14468263brushy
bugsha1233823bugsha
buqsha2032793buqsha
chrisma1456823chrisma
coria75828323cori__a
coyish143710393coyish_
crash109120013crash_
cris66233433cris__
crises84529433crises
crisic103611843crisic
crisis83716343crisis
crisp95014623cris_p
crisps104411513crisps
crispy13478563crispy
crissal937413crissal
cristae9310613cristae
crush106815993crush_
cuish10313173cuish_
dish86328333_dish_
dishy125712353_dishy
dorsa64617283dor_s_a
dovish1338103dovish_
dryish1336323dryish_
erica7316543eri_ca
farinha13357063farinha
fish106926273_fish_
fishy146011663_fishy
fresh115012203fresh_
fright133715243fright
frise85322453fris_e
frisee94217993frisee
frises94124273frises
frisk125312373fris_k
frisks13479263frisks
frisky16406673frisky
frith115922033frith_
friths124313583friths
frosh115713403frosh_
frusta937453frusta
garish104516923garish_
geishas1135083geishas
girsh95310023girsh_
gorilla836973gorilla
goyish13379013goyish_
gringa838553gringa
grisly104310583grisly
grison7310103grison
grist65529873gris_t
grists74716483grists
grith95520373grith_
griths105211653griths
harissa1035503harissa
heishi1235843heishi
iris45732553iris__
irised73913153irised
irises64221173irises
isba61310883__isba
kasha124710723_kasha
kishka1232963_kishka
knish1238603knish_
kris86423603kris__
krises105016083krises
lorica8310443lori_ca
loris55329153loris__
lorises73918593lorises
lowish12310533lowish_
marish114319053marish_
mishap1338873_mishap
modish123813543modish_
monish114217593monish_
moorish123311783moorish_
mopish134311593mopish_
noirish1037883noirish_
noria55722183nori__a
noris54928273noris__
nourish1039703nourish_
oafish121311723oafish_
oarfish13158613oarfish_
obia67923113obi__a
obis66226843obis__
oddish11107653oddish_
odist6421913odis_t
odists749853odists
offish15137273offish_
ogreish1134673ogreish_
ogrishly1544033ogrishly
ogrism937913ogris_m
ogrisms1036443ogrisms
ohia75719363ohi__a
oidia6314953o_idia
oldish10169313oldish_
omasa749483omas_a
onrush935343onrush_
ora37250833or___a
orach105219233orach_
orache114013593orache
orbs66626253orbs__
orca65522773or__ca
orcs67025433orcs__
ores46056683ores__
organa789213organa
oribi7311093ori_bi
oribis838833oribis
oriel54920423ori_el
oriels64914623oriels
orient6322533orient
origan7310693origan
origin7311033origin
oriole6814293oriole
orisons7310563orisons
ornis54616773ornis__
orphan1137733or_phan
orra46120723or__ra
orris54516553orris__
orrises71312233orrises
ors35750113or_s__
ortho8312293or_tho
orts46538333orts__
ossa43714163o__ssa
ossia53710403o_ssia
ovisac1153953ovisac
owlish1238703owlish_
paisa76021073pais_a
parish115022353parish_
pasha105417183_pasha
perish114619063perish_
pish96127913_pish_
polish114916723polish_
poorish123712303poorish_
popish133812113popish_
porism104518063poris_m
porisms113713453porisms
presa74319043pres_a
prima95019343pri_ma
prise74632613pris_e
prised94322203prised
prises84133173prises
prism94820263pris_m
prisms104915503prisms
prison8514023prison
priss74623893pris_s
prissy11347853prissy
rash76039933_rash_
resh76523453_resh_
ria36745503_ri__a
riata54618023_riata
rich97025543_rich_
ricksha1643123_ricksha
right94430503_right
rikisha1442343rikisha
rikshaw1762873_rikshaw
rioja1236303_rioja
rise45945233_ris_e
risen54621883_risen
riser55431053_riser
rises55244043_rises
rishis9312453_rishis
risk85724103_ris_k
risks94917063_risks
risky126311523_risky
ristra6310713_ristra
risus54216393_risus
roshi8310753_roshi
rush76628183_rush_
rushy115414813_rushy
sha69837783___sha
sourish10310693sourish_
sradha1085333sradha
sris45434153sris__
swish115114823swish_
swishy15365843swishy
tonish93415903tonish_
tourista844403tourista
toyish122911123toyish_
trash86119763trash_
trashy12509053trashy
trishaws1444003trishaws
triste63818643triste
trivia938503trivia
turista737443turista
ursa44116913ur_s_a
visa76323873_vis_a
vista85416603_vista
whish144512923whish_
whisht154510813whisht
whorish1636603whorish_
wish107228733_wish_
wormish1537163wormish_
wright133713513wright
wrist84827563wris_t
wrists95415643wrists
wristy12509703wristy
writhe125310703writhe
zorilla1646023zorilla
zoris145320013zoris__

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 Filter1786911127160.376475242.0
2DLD Change Limit1127162355.71619719.4
3Display Results2352350.0633730.2
 (SQL Overall)1786912356.15529031.8
 
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.