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

105 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
fumulus123444(None) 
cumulus1135451cumulus
famulus1235041famulus
tumulus935031tumulus
cumulous1245272cumulous
fumbles143514412fumbles
fumuli1135262fumul_i
hamulus1235322hamulus
limulus935082limulus
tumulous1045302tumulous
tumults934822tumults
annulus7426613annulus
bumbles134016843bumbles
cumuli1036273cumul_i
cupules113210263cupules
emulous937343_emulous
fabulous1344853fabulous
famous11412393fam_ous
famuli1136763famul_i
fatuous1037783fatuous
faulds10438963f_aulds
faults94513553f_aults
females12310663females
femurs1136713femu_rs
ferulas103110753ferulas
ferules103112723ferules
fibulas12228563fibulas
fimbles143510663fimbles
flus75626543f___lus
formulas1346303formulas
fouls87221433f_oul_s
fucous11399863fu_cous
fucus105515893f__ucus
fucuses12158353fucuses
fuddles123611933fuddles
fuels87117353fu_el_s
fugles104715783fu_gles
fugues104511683fugu_es
fugus95914013f__ugus
fulls84623523f__ulls
fulvous1334543fulvous
fumble133214263fumbl_e
fumbled153710493fumbled
fumbler143610813fumbler
fumblers15318713fumblers
fumeless13236603fumeless
fumers113613383fum_ers
fumes105224703fum__es
fumets114311813fum_ets
fundus10429173fu_ndus
fungous11367433fungous
fungus10418183fu_ngus
funiculus1443473funiculus
furculum1542913furculum
furious103110633furious
furls85322053fu_rl_s
fuscous1256673fuscous
fusels94412453fusel_s
fusils93912343fusil_s
futures10310263futures
fuzils18407963fuzil_s
gummous1236263gummous
hamulous1344923hamulous
humbles143215803humbles
humerus1236913humerus
hummus1336243hum_mus
humus106215073hum__us
humuses1237593humuses
jugulum1742503jugulum
jumbles183013323jumbles
loculus9296973loculus
lulus54315163__lulus
lunules738953lunules
modulus10245333modulus
mucus94015743__mucus
mules75034293__mules
mulls75124153__mulls
mumbles133014433mumbles
mumus95517283__mumus
mutules9311843mutules
muumuus1141763muumuus
numbles113814273numbles
oculus8178393_oculus
ormolus934743ormolus
plumules1234663plumules
pumelos11196093pumelos
ramulous1045883ramulous
regulus836523regulus
rumbles114018393rumbles
rumples113313133rumples
rumpus10458893rum_pus
stimulus1044333stimulus
sulus54821883__sulus
surplus936793surplus
tubules9310233tubules
tubulous1045373tubulous
tumbles113816023tumbles
tumular9236543tumular
tumuli835933tumul_i
tumulose1043553tumulose
tumult839703tumul_t
tumuluses1143123tumuluses
ulus45622563___ulus
umbles103817493_umbles
uvulas946523_uvulas

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.423422437.4
2DLD Change Limit1340271057.26318453.4
3Display Results1051050.0801312.5
 (SQL Overall)1786911057.76623009.4
 
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.