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

183 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
dervish143698(None) 
darkish1537942darkish
deafish1438532deafish
delish105215612de_lish
dermis94717162dermis_
derris73615272derris_
dervishes1644932dervishes
devise104215752de_vise
dovish1338102d_ovish
dryish1336322d_ryish
elvish1277562_elvish
nerdish1137102nerdish
peevish1535782peevish
perish114619062per_ish
perkish16258822perkish
serfish1348972serfish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
burnish1238623burnish
carlish12312773carlish
ceorlish1345383ceorlish
cercis104614493cercis_
ceriph1398463cer_iph
cerise84822043cer_ise
cervid1239323cervi_d
cervine122610803cervine
cervix1865163cervi_x
cherish15310463cher_ish
clerkish1744263clerkish
currish1238353currish
dampish1567663dampish
danish101513813d_anish
dealfish1545503dealfish
deash95617243de__ash
deaves105319533deaves_
deaving123814753deaving
debris93311493debris_
debruise1143913debruise
defis96717503de_fis_
deism84116033de__ism
deist64633593de__ist
deixis1437243deixis_
delis64928543de_lis_
delist74625053de_list
delves104917083delves_
delving123711573delving
demise94618323de_mise
demolish1447833demolish
dentist8316743dentist
depolish1446943depolish
deraign936573deraign
derail74218813derai_l
derails84216393derails
derats74625063derats_
derays105514253derays_
derbies103016053derbies
deride84420033der_ide
derive103817043der_ive
derived123912763derived
deriver114213913deriver
derives114017813derives
deriving132510743deriving
dermas94116823dermas_
dermic114511913dermi_c
dermises112512023dermises
derms85022893der_ms_
dernier83011943dernier
derrick1435803derrick
derries83124623derries
derrises93012783derrises
desist74818813de_sist
despise1038683despise
devas96218883de_vas_
devest104418703de_vest
device124512163de_vice
devil94714733de_vi_l
devilish1546373devilish
devils104412813de_vils
devisal1136913de_visal
devised123712563de_vised
devisee113812713de_visee
deviser114212393de_viser
devises114116763de_vises
devisor11357043de_visor
devs86424033de_v_s_
dish86328343d___ish
dogfish15226763dogfish
doggish13237533doggish
dollish11610093dollish
doltish11118733doltish
donnish11187633donnish
dreggish1453133dreggish
dreich12377723d_reich
dreigh11246443d_reigh
dronish1138913dronish
dudish1148313d_udish
dullish1148743dullish
dumpish15116113dumpish
duncish1335793duncish
duskish1535183duskish
dwarfish1843783dwarfish
dweebish1742183dweebish
elfish1267963_elfish
enravish1444243enravish
ervil8310303_ervi_l
ervils948773_ervils
fermis114313503fermis_
fervid1337513fervi_d
fetish12310373fe_tish
furbish1536443furbish
furnish1337383furnish
garfish14179203garfish
garish104516933gar_ish
garnish111610853garnish
girlish1137193girlish
greyish1435173greyish
heimish1535463heimish
hellish13310723hellish
hennish1336863hennish
heroism12311013heroism
jewfish2343543jewfish
kermis124012403kermis_
knavish1743993knavish
largish1138603largish
larkish1439083larkish
lavish124112993_lavish
leftish13197253leftish
levis85818553le_vis_
marish114319063mar_ish
nebbish1444253nebbish
nereis6315343nereis_
nerves94216193nerves_
nervier10298843nervier
nerviest11188833nerviest
nervily1336863nervily
nervine102510633nervine
nerving112910833nerving
newish1237903ne_wish
oarfish13158613oarfish
ogreish1134673ogreish
ogrish1039263ogr_ish
overfish1737893overfish
parish115022363par_ish
parvis116114803parvis_
parvise124211693parvise
peakish16268873peakish
peckish18227293peckish
pelvis113610323pelvis_
peris75537073per_is_
persist9315853persist
pervs105117373perv_s_
pettish1238283pettish
previse123713803previse
ravish123414043_ravish
reddish1238033reddish
redfish1437793redfish
relish93916953re_lish
reraise7316313reraise
rerise64325633rer_ise
revise94019753re_vise
selfish1388513selfish
serais64326133serais_
serves94423653serves_
service1239093service
servile10310643servile
serving113014983serving
servos93812723servos_
slavish1338233slavish
tarnish101611883tarnish
tartish101512633tartish
terais64023513terais_
varnish13169553varnish
verism113214263ver_ism
verist93823893ver_ist
vermis114214963vermis_
verves124617883verves_
warmish1538373warmish
weakish17217173weakish
wearish132310153wearish
wennish1336243wennish
wettish1335963wettish
wormish1537163wormish

Search took 10 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.453394461.4
2DLD Change Limit1340271838.59315597.2
3Display Results1831830.0632904.8
 (SQL Overall)1786911839.10919617.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.