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

124 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
nimblest123692(None) 
fimbles143510662fimbles_
humblest15288282humblest
limbiest12258892limbiest
limbless12246312limbless
nibbles114011692nibbles_
nimble103412942nimble__
nimbler11358062nimble_r
noblest93613562n_oblest
nombles113212342nombles_
numbest1138792numb_est
numbles113814272numbles_
simplest122310222simplest
wimbles143010852wimbles_
ablest84721833__ablest
aimless93610813aim_less
ambles105121863_ambles_
amplest11312333_amplest
animalist11511643animalist
bibles104617643bi_bles_
bibless11439173bi_bless
biblist11310833bi_blist
bimboes13498733bimboes_
blest76431723___blest
bomblet13412263bomble_t
bomblets1436023bomblets
bumbles134016843bumbles_
dibbles124013333dibbles_
dimmest1249253dim_mest
dimples122813213dimples_
dimpliest1436583dimpliest
dismalest1246313dismalest
dumbest1238743dumb_est
feeblest1336913feeblest
ficklest17267903ficklest
fimble133611753fimble__
fumbles143514413fumbles_
gambles124016203gambles_
giblet93418893gi_ble_t
giblets103210423gi_blets
gimlet93716663gim_le_t
gimlets10338433gim_lets
gimpiest1338473gimpiest
humbles143215803humbles_
idlest74014863_i_dlest
illest63615723_i_llest
imbues1037983_imbues_
imprest11310203_imprest
jimpest18297553jim_pest
jumbles183013323jumbles_
kibbles153510253kibbles_
kittlest12297573kittlest
lambiest122410183lambiest
limberest1345513limberest
limeless10249663limeless
limiest93716103lim_iest
limpest113712313lim_pest
littlest8309243littlest
micklest16219123micklest
molest85022743__molest
mumbles133014433mumbles_
nameless10248373nameless
nibble103713283nibble__
nibbled12389073nibble_d
nibbler11379273nibble_r
nibblers12306543nibblers
nicest82315663ni__cest
nickles133713823nickles_
niellist848353niellist
niftiest112910073niftiest
niggles93512203niggles_
niggliest1144933niggliest
nighest11310693ni_ghest
nihilist1147163nihilist
nimbleness1445593nimbleness
nimbly13388773nimbl__y
nimbus10377283nimb_us_
nimbused1343013nimbused
nimbuses1244663nimbuses
nimbyness1641543nimbyness
nippiest12279973nippiest
nipples11319663nipples_
nittiest82712603nittiest
nobbiest12117773nobbiest
nobbles114014523nobbles_
nobles83319723n_obles_
nubbiest12117313nubbiest
nubbles113412433nubbles_
nubbliest1354363nubbliest
numbness1234413numbness
pimples133012423pimples_
pimpliest1545473pimpliest
rambles113118313rambles_
ribbiest1237583ribbiest
ribless93410343ri_bless
riblet84222443ri_ble_t
riblets93412553ri_blets
rimiest93215853rim_iest
rimless9369363rim_less
rimples113114223rimples_
rumbles114018393rumbles_
similes92915233similes_
simples113014943simples_
simplist12249683simplist
stablest103312943stablest
thimbles1536023thimbles_
timbales12227843timbales_
timbres11249353timbres_
timeless10239543timeless
timeliest1147233timeliest
timidest1136933timidest
tombless1236783tombless
tumbles113816023tumbles_
tumbleset1345373tumbleset
umbles103817493_umbles_
unblest9411813_unblest
vilest9416843vi__lest
wambles143714023wambles_
wambliest16255153wambliest
wimble133211923wimble__
wimbled15298153wimble_d
wimpiest1538763wimpiest
wimples143311173wimples_
wombiest1536893wombiest

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621247.39319770.3
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.87522690.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.