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

61 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
eardrop106522(None) 
eardrops1165301eardrops
teardrop1153101teardrop
airdrop1044422airdrop
eardrum10135422eardrum
hardtop1345052hardtop
paradrop1344602paradrop
teardrops1263292teardrops
airdrops1144343airdrops
andro6314163_andro_
andros7313303_andros
ardor64617863_ard_or
ardors74416873_ardors
arrow83414883_ar_row
backdrop19114253backdrop
barhop13319643bar_hop
barrow114512763bar_row
caldron1038153caldron
caltrop11267643caltrop
cardio9915673cardio_
cardon94120853card_on
cardoon104813813cardoon
carhop133610763car_hop
carrom10513403car_rom
carrot8423123car_rot
cartop104213563car_top
dewdrop1442813dewdrop
drop75324403___drop
eardrums11524483eardrums
earflap1243273earflap
earlap837183ear_lap
earldom1044583earldom
earshot10410833earshot
earworm1238743earworm
eavesdrop1551273eavesdrop
error53712233e_r_ror
eyedrops1443163eyedrops
farrow12309973far_row
garron73113493gar_ron
gumdrop1342513gumdrop
hadron102913753ha_dron
hardtops1444843hardtops
harrow122610773har_row
karroo10410013kar_roo
ladron73413323la_dron
lardon74415063lard_on
lardoon83410373lardoon
larrup835713lar_rup
marron83717543mar_ron
marrow112812603mar_row
narrow9269143nar_row
outdrop1036193outdrop
paradrops1444963paradrops
pardon94618733pard_on
parrot8320663par_rot
raindrop1142783raindrop
tardo65321103tard_o_
tardyon1134673tardyon
wardrobe1464133wardrobe
wardroom1445043wardroom
yarrow12287933yar_row

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 Filter1786911340270.406440125.6
2DLD Change Limit134027617.08018930.4
3Display Results61610.0302033.3
 (SQL Overall)178691617.51623774.7
 
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.