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

118 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
blondine113715(None) 
blondined1343481blondined
blondines1246151blondines
blending12249962blending
blinding123210162blinding
blonde94813292blond__e
blondish1476172blondish
blooding122410652blooding
bloodline1245172bloodline
bonding113318432b_onding
clonidine1286152clonidine
klondike1241662klondike
alanine7316863alan_ine
alcidine1148233alcidine
almandine1245393almandine
amandine1148553amandine
banding114921413b_anding
belonging1335913belonging
bending114420893b_ending
benzine1839343b_enzine
binding113819383b_inding
bisontine1145673bisontine
blading113615363bl_ading
blandish1497003blandish
blanking154411933blanking
bleeding12359053bleeding
blende95413443blend__e
blindage1243683blindage
blindside1342753blindside
blinking153510623blinking
bloating113512813bloating
blobbing12246923blobbing
blocking174510573blocking
blogging13369013blogging
blond85618373blond___
blonder104011943blond_er
blondes104213163blond_es
blondest11419243blondest
blondining1462983blondining
blondness1234963blond_ness
blonds95213343blond__s
bloodfin1443393bloodfin_
bloodfins1543753bloodfins
bloodied1245973bloodied
bloodier1136823bloodier
bloodies11310163bloodies
bloodily1445183bloodily
bloodiness1344353bloodiness
bloodings13245273bloodings
bloodlike1643863bloodlike
bloodlines1344183bloodlines
bloodying1643783bloodying
blooie83913193blo_oi_e
blooming13299433blooming
blooping13248843blooping
blotting113910433blotting
blousing1138793blousing
blowing133813053blo_wing
blowpipe1742353blowpipe
blueline1036873blueline
blunging12328413blunging
blunting11319843blunting
bodice11711423b_o_dice
boding104320063b_o_ding
bondage1138253b_ondage
bondings12369413b_ondings
bondmen1237893b_ondmen
bonfire1287063b_onfire
bonging113316373b_onging
boning94223293b_on_ing
bonking144116373b_onking
bonne75124713b_on__ne
bonnie85314853b_onni_e
boudin9412373b_oudin_
boudins10311313b_oudins
bounding123012133bounding
bovine11712433b_o_vine
bowline123613113b_owline
branding122513683branding
bromine112915243bro_mine
bronzing2037693bronzing
brooding122911373brooding
celandine1245623celandine
clonidines1374553clonidines
cloning103215473clon_ing
clonking153810153clonking
clouding12269493clouding
condone102616293_condone
confine12315583_confine
coniine9316803_coniine
conine84528553_con_ine
flooding13238963flooding
fonding123815423_fonding
gliadine1045403gliadine
glonoin875673glonoin_
glonoins955843glonoins
iodine74618653_io_dine
klondikes1341473klondikes
landing92819323_landing
landline9311443_landline
lending94118533_lending
leonine7311233leon_ine
lindane839033_lindane
loading94114613_loading
loiding93313403_loiding
longing93915783_longing
longline938763_longline
lording93115233_lording
online6315843__online
plodding13166343plodding
plonking15358563plonking
plotline1037643plotline
ponding114317083_ponding
pontine92419053_pontine
sordine82515233_sordine
tolidine948193tolidine
tontine72316143_tontine
undine7817263__undine

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 Filter1786911461620.500357382.0
2DLD Change Limit1461621187.59319249.6
3Display Results1181180.0502360.0
 (SQL Overall)1786911188.14321944.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.