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

143 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
orishas103647(None) 
orisha936771orisha_
aristas7413522aristas
geishas1135082geishas
orisons7310562orisons
rishis9312452_rishis
trishaw1344752trishaw
trishaws1444002trishaws
aorists74215833aoris_ts
arias55438023ari__as
arises65233803aris_es
arista6415293arista_
aristae7312533aristae
aristos7312373aristos
baristas1039723baristas
borshts1266543bor_shts
brashes124518463brashes
brights133710233brights
brises84927613bris_es
brisks124611403bris_ks
briss75824273bris__s
brisses94314313brisses
briths115113863brith_s
britskas14132713britskas
brushes124014663brushes
bugshas1334513bugshas
buqshas2143573buqshas
crashes124618403crashes
crises84529433cris_es
crisis83716343cris_is
crisps104411513cris_ps
crissa837623crissa_
crissal937413crissal
crista8311803crista_
cristae9310613cristae
crushes124215133crushes
cuishes122810823cuishes
dishes104622653_dishes
ericas8315463eri_cas
farinhas14325363farinhas
fishes125221343_fishes
freshes133515823freshes
frights14339623frights
frisees104411693frisees
frises94124273fris_es
frisks13479263fris_ks
friths124313583frith_s
geisha1035213geisha_
girshes11248293girshes
gorillas946373gorillas
gringas938043gringas
grisons838993grisons
grists74716483gris_ts
griths105211653grith_s
harissas1145983harissas
irises64221173iris_es
isbas71010403__isbas
kashas133311903_kashas
kishkas1343483_kishkas
knishes1438263knishes
krises105016083kris_es
lorises73918593loris_es
marishes13512553marishes
mishap1338873_mishap
mishaps1438723_mishaps
monishes13311483monishes
norias65518203nori__as
nourishes12116733nourishes
oarfishes15156953oarfishes
obias76116863obi__as
odists749853odis_ts
ogrish1039263ogrish__
ogrishly1544033ogrishly
ogrisms1036443ogris_ms
ohias84415573ohi__as
onrushes1135213onrushes
oraches124216473oraches
orcas75918623or__cas
orchis11710773or_chis
oribis838833ori_bis
oriels64914623ori_els
orients7311583orients
origan7310693ori_gan
origans839973origans
origins8310463origins
orioles7412993orioles
orison6411663oris_on
ornithes1136423ornithes
orphan1137733or_phan
orphans1237773or_phans
orrises71312233orris_es
ovisac1153953ovis_ac
ovisacs1263283ovisacs
paisas84317493pais_as
parishes13314753parishes
pashas115117063_pashas
perishes13313753perishes
pishes114722103_pishes
poisha1135723poisha_
polishes13711783polishes
porisms113713453poris_ms
primas104418103pri_mas
prises84133173pris_es
prisms104915503pris_ms
prisons9313223prisons
priss74623893pris__s
prisses94816713prisses
rashes95330153_rashes
reshes94124363_reshes
rias45540593_ri__as
riatas63915093_riatas
riches115022083_riches
rickshas1743843_rickshas
rights104019333_rights
rikishas1542543rikishas
rikshaw1762873_rikshaw
rikshaws1852653_rikshaws
riojas1335813_riojas
risers64624783_risers
rises55244043_ris_es
rishi8311253_rish_i
risks94917063_ris_ks
ristras7311563_ristras
risus54216393_ris_us
roshis9311793_roshis
rushes94724363_rushes
sradhas1176153sradhas
swishes133411373swishes
touristas943373touristas
trashes104119263trashes
triphase1346193triphase
trismus935563trismus
turistas846693turistas
visas84317653_vis_as
vistas94513273_vistas
whishes16309443whishes
whishts16425313whishts
wisha114910853_wisha_
wishes124920953_wishes
wrights14318993wrights
wrists95415643wris_ts
writhes134811703writhes
zorillas1745483zorillas

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.436409841.7
2DLD Change Limit1340271437.11018850.5
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.60923484.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.