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

77 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
nielloed96386(None) 
helloed113512422_helloed
hilloed113211292hi_lloed
niello636602niello__
niellos736142niello_s
nilled73919452ni_ll_ed
belled94626183_bell_ed
bellied104314073_bellied
bellowed14158603_bellowed
bielded11226713bie_lded
billed94224903bi_ll_ed
billowed14137063bi_llowed
celled94420323_cell_ed
dialled9510133diall_ed
dilled84122223di_ll_ed
duelled9359753duell_ed
dwelled12337593dwell_ed
felled103720303_fell_ed
felloe93513923_felloe_
felloes104114383_felloes
fellowed15136833_fellowed
fielded12206813fie_lded
filled104922263fi_ll_ed
fuelled11369193fuell_ed
gelled84718893_gell_ed
gilled84521633gi_ll_ed
gillied95512313gi_llied
halloed113314913_halloed
helled104024703_hell_ed
helloes103717463_helloes
hilled104022223hi_ll_ed
hilloaed12136923hi_lloaed
hilloes103815953hi_lloes
holloed113812753_holloed
hulloed11369793_hulloed
jelled144916063_jell_ed
jellied15419223_jellied
killed113918773ki_ll_ed
knelled12338983knell_ed
kvelled15276063kvell_ed
libelled11317213libell_ed
melled95023023_mell_ed
mellowed14166923_mellowed
milled94326173mi_ll_ed
needled9358513needl_ed
nellie63614813n_ellie_
nellies73418723n_ellies
nibbled12389073nibbl_ed
nickelled1653793nickell_ed
nickled144010443nickl_ed
nielli636303niell__i
niellist848353niellist
nielloing1043893nielloing
niggled10319203niggl_ed
nippled12307643nippl_ed
nulled74318273n_ull_ed
pilled94222753pi_ll_ed
pillowed14156383pi_llowed
quelled17279273quell_ed
rilled74525653ri_ll_ed
shelled113815083shell_ed
siloed74615303si__loed
smelled103511853smell_ed
snelled83313043snell_ed
snivelled1353993snivell_ed
spelled103714733spell_ed
swelled113211693swell_ed
tilled74722953ti_ll_ed
vialled1156843viall_ed
welled103820213_well_ed
wielded12216683wie_lded
willed104722453wi_ll_ed
willied114611563wi_llied
willowed15156763wi_llowed
yelled104116253_yell_ed
yellowed15185743_yellowed
yielded12184713yie_lded

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 Filter1786911461620.1701051123.5
2DLD Change Limit146162779.45315462.0
3Display Results77770.0332333.3
 (SQL Overall)178691779.65618505.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.