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 “dervishes” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
dervishes164493(None) 
dermises112512022dermis_es
derrises93012782derris_es
dervish1436982dervish__
devisees12358282de_visees
devises114116762de_vis_es
perishes13313752per_ishes
burnishes1436643burnishes
cercises12410933cercis_es
cerises94722253cer_is_es
cervices1537133cervi_ces
cervixes2054603cervi_xes
ceviches1834843ce_viches
cherishes1767563cher_ishes
danishes121710493d_anishes
dealfishes1744193dealfishes
deashes113313903de__ashes
debruises1243633debruis_es
dehisces1464713de_hisces
deixises1635693deixis_es
demises103719563de_mis_es
demolishes1684903demolishes
depolishes1694123depolishes
derbies103016053derbi__es
derides93420853der_i_des
derivates13310093derivates
derives114017813der_i_ves
derrieres1044813derrieres
derries83124623derri__es
despises1139433despis_es
deviates12312733de_viates
devices133212583de_vi_ces
devisals1245613de_visals
devise104215753de_vis_e_
devised123712563de_vis_ed
devisee113812713de_vis_ee
deviser114212393de_vis_er
devisers12339863de_visers
devisors12347253de_visors
dishes104622653d___ishes
dogfishes1745083dogfishes
enravishes1642153enravishes
fetishes1437153fe_tishes
furbishes1745243furbishes
furnishes1536233furnishes
garfishes16167083garfishes
garnishes13198813garnishes
jewfishes2543383jewfishes
kermises14248313kermis_es
lavishes1457403_lavishes
marishes13512553mar_ishes
merises93421423mer_is_es
nebbishes1642973nebbishes
nervines112310463nervi_nes
oarfishes15156953oarfishes
overfishes1947013overfishes
parishes13314753par_ishes
parvises133911913parvis_es
pelvises1337273pelvis_es
perished14310073per_ished
previses133814283previs_es
ravishes1478043_ravishes
redfishes1645793redfishes
relishes11311953re_lishes
reraises8415643rerais_es
rerises73525883rer_is_es
revises104220533re_vis_es
services1338573servi_ces
seviches1635803se_viches
tarnishes12188893tarnishes
varnishes15207913varnishes

Search took 9 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 Filter1786911486410.1701051123.5
2DLD Change Limit148641718.00318573.2
3Display Results71710.0302366.7
 (SQL Overall)178691718.20321783.6
 
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.