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

87 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
felonry1329484(None) 
felony123710321felon_y
falconry1642542falconry
felon84619292felon__
felons93615762felon_s
floury12449572f_loury
helotry1345652helotry
heronry1346042heronry
almonry12104733almonry
baloney1237483baloney
belfry1435073bel_fry
belon73924113belon__
belong93411043belon_g
belongs10408223belongs
belons84119413belon_s
betony114211583beton_y
beworry1543743beworry
boloney1247763boloney
calory11312843calo_ry
canonry1235923canonry
celery1139623cel_ery
colony115417273colon_y
deaconry1443323deaconry
ebony104511513_ebon_y
fedora1038593fedo_ra
feline94820143felin_e
felinely1445953felinely
felines104718073felines
felinity1447293felinity
feller94419553feller_
fellers104117543fellers
fellowly17264093fellowly
felly114922803fel__ly
felonies11310993felonies
felonries1246203felonries
felwort13410583felwort
femora1149583femo_ra
fenny115115133fe__nny
feodary1444713feodary
fernery1335813fernery
ferny115816183fe_rn_y
ferry116020803fe__rry
fetor81214533feto_r_
fetors91014473feto_rs
feudary1444273feudary
fleury12417353f_leury
flinty126112493f_linty
floaty124210943f_loaty
flocky18468423f_locky
flong95815683f_lon_g
flongs105010493f_longs
flooey123910173f_looey
floor84215233f_loor_
floors94112353f_loors
floosy12368153f_loosy
floozy21356613f_loozy
floppy1654873f_loppy
flora85317103f_lo_ra
flossy12517703f_lossy
flouncy1543673f_louncy
flour84916453f_lour_
flours94414053f_lours
flowery16327783f_lowery
flunky16408093f_lunky
flurry12397113f_lurry
foolery1336693foolery
fullery13337973fullery
glory96413293_glo_ry
hellery13329213hellery
henry114014473he__nry
lemony11419553lemon_y
lorry86315673__lorry
lory75931713__lo_ry
loury85716753__loury
masonry1244123masonry
melody1237203melo_dy
melon73922083melon__
melons84117713melon_s
memory1338803memo_ry
pelon74423213pelon__
peltry11288653pel_try
peony105717563pe_on_y
velour9328763velour_
velours10278083velours
weaponry1642023weaponry
zealotry2042303zealotry
zedoary2043213zedoary

Search took 7 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 Limit134027876.26621389.6
3Display Results87870.0302900.0
 (SQL Overall)178691876.70226662.3
 
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.