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

101 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
finaglers1317389(None) 
finagler12194951finagler_
finagles12237551finagle_s
fenagles12186082fenagle_s
finagle11238312finagle__
finagled13205292finagle_d
finales104016012fina_le_s
fingers113418432fin_g_ers
jinglers16408762jin_glers
minglers113011292min_glers
tinglers93710592tin_glers
anglers84014823_an_glers
bingers104519993bin_g_ers
bunglers11398483bun_glers
canallers1137213canallers
danglers103610593dan_glers
dialers83614303di_a_lers
diallers957773di_allers
dingers94321383din_g_ers
dingles93818323din_gle_s
disablers1255803disablers
enablers10196913_enablers
fablers124812613f__ablers
fallers103917993f__allers
fangless1237663fan_gless
fenagle11197153fenagle__
fenagled13184853fenagle_d
fiddlers13328283fi_ddlers
filagrees1373883filagrees
filers94623723fi___lers
fillers104320213fi__llers
filmgoers1541983filmgoers
finable122213623finable__
finagling1434703finagling
finale94116763fina_le__
finalis103313663fina_l_is
finalizers22264903finalizers
finals94316163fina_l__s
finances1338653finance_s
financiers1542383financiers
finders113717873fin__ders
finger104920333fin_g_er_
fingerers13136303fingerers
finishers1545353finishers
finless102810783fin__less
flaggers13328073f_laggers
flagless1235403f_lagless
flangers123311373flang_ers
flingers123410193flin_g_ers
fondlers12338023fon_dlers
foragers12349633forag_ers
gigglers11297403gi_gglers
gingers94118643gin_g_ers
higglers13297233hi_gglers
hingers113420213hin_g_ers
imagers10107763_imag_ers
ingles74420873_in_gle_s
inhalers1166643_inhalers
inhaulers1263243_inhaulers
janglers16319373jan_glers
jingler154311093jin_gler_
jingles153816383jin_gle_s
kindlers13318483kin_dlers
kingless13288693kin_gless
kinglets13318583kin_glets
linages8813173linag_e_s
lingers84223303lin_g_ers
managers112911003manag_ers
manglers113311903man_glers
mingler104213843min_gler_
mingles103719003min_gle_s
naggers93812653__naggers
nailers73215893__nailers
nigglers10307253ni_gglers
onagers838103_onag_ers
pinasters1136823pinasters
pingers104020743pin_g_ers
ringers83922953rin_g_ers
ringlets92910233rin_glets
shinglers13246443shin_glers
signalers1044583signa_lers
signallers1142843signallers
singers83824703sin_g_ers
singles83520433sin_gle_s
singlets93611473sin_glets
snarlers8298753_snarlers
snigglers11314593snigglers
tanagers9259003tanag_ers
tanglers92911973tan_glers
tingler83613343tin_gler_
tingles83818323tin_gle_s
tinklers12298183tin_klers
twanglers1363433twanglers
vintagers13123903vintag_ers
wanglers123310033wan_glers
wigglers13257213wi_gglers
wingers113921483win_g_ers
wingless122910023win_gless
winglets12299593win_glets
wranglers1344273wranglers
zingers173514853zin_g_ers

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411017.28020417.7
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.74923059.9
 
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.