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

83 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
rellenos812549(None) 
relleno796461relleno_
reblends1135292reblends
relends84013252re_lends
relents74018502re_lents
relievos11374382relievos
belleeks1444363belleeks
belles85325993belle__s
bellings113811153bellings
cellos84517803cell__os
eluents738703_eluents
fellers104117543felle_rs
fellness1135913fellness
galleons9258443galleons
gellants9308283gellants
helleris113010183helleris
hellers103619833helle_rs
hellions11310023hellions
hellos95321683hell__os
jellos134714283jell__os
lenos56024863___lenos
llanos6108333__llanos
melenas999203me_lenas
mullens93611313mullen_s
pellets94014783pelle_ts
pollens93713303pollen_s
reagents959623reagents
reales64934123reale__s
realness8410443realness
reblend1036653reblen_d
reblent9614253reblen_t
recleans1037513recleans
reclines103718543reclines
reddens9259783redden_s
redlegs936823redle_gs
redlines93916083redlines
reelects103110883reelects
reelers73520273reele_rs
reelings94012563reelings
reflects13288873reflects
reflets103513153refle_ts
reflexes1865933reflexes
regents83416543re_gents
reglets83512983regle_ts
relands85214883re_lands
relend76116453re_len_d
relent64431853re_len_t
relets64025673re_le_ts
releves103914973re_leves
reliefs10439433relie_fs
reliers75519213relie_rs
relies65036423relie__s
relieves114210393relieves
relievo10425773relievo_
relines75331323re_lines
relinks114510223re_links
reloans7313133reloan_s
remends105013033re_mends
reopens939373reopen_s
repellents1245143repellents
repents93717623re_pents
replans92814943replan_s
replants102811243replants
repleads11357213repleads
replenish1445163replenish
repletes102812473repletes
reredos838633re_redos
rerents73319423re_rents
resends83513713re_sends
resents74221223re_sents
retenes76324623re_tenes
rezeros1647453re_zeros
rilles64725503rille__s
rillets74216153rille_ts
ripienos1043483ripienos
rollers73117473rolle_rs
rollings9419953rollings
selenous848973se_lenous
sellers73721323selle_rs
selles64426983selle__s
tellers73717603telle_rs
wellness1135793wellness
yellers103912953yelle_rs

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 Filter1786911461620.423422437.4
2DLD Change Limit146162837.32619951.1
3Display Results83830.0332515.2
 (SQL Overall)178691837.78222962.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.