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

57 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
bumelia114526(None) 
bumelias1245061bumelias
camelia11510432camelia
abelia83114403_abelia
abulia83512503abu__lia
aphelia1249423aphelia
babesia1146623babesia
belga8313233b__elga
belie75630383b__elie
bohemia1446363bohemia
borrelia1044553borrelia
bromeliad1453253bromeliad
bromelin1246343bromelin
brucella1243343brucella
bubalis11359903bubalis
bucolic1345593bucolic
buddleia1242233buddleia
bulimia1145043bulimia
bulla74620563bu__lla
bumble124216893bumbl_e
bumbled144113043bumbled
bumbler134013233bumbler
bumbles134016843bumbles
bumbling15249763bumbling
bumkin14308083bum_kin
bumpily1665653bumpily
bumpkin1743613bumpkin
buzukia2242223buzukia
camelias12510303camelias
camelid1249413camelid
camellia1255443camellia
cumbia12379893cum_bia
cumuli1036273cumuli_
dulia61014983du__lia
eugenia847713eugenia
fumelike1735223fumelike
fumuli1135263fumuli_
humeri1138523humeri_
hymenia1546393hymenia
lamella988613lamella
lobelia947213lobelia
media84721713__media
melic94722333__melic
milia72719573__milia
mycelia1444843mycelia
numeric1158193numeric
obelia8329453_obelia
plumeria1244903plumeria
pumelo10257113pumel_o
pumelos11196093pumelos
qualia1559563qu_alia
quelea1547303qu_elea
rubella9146523rubella
telia55821143__telia
tumuli835933tumuli_
uredia73610063_uredia
uremia82910893_uremia

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.420425454.8
2DLD Change Limit134027575.75323296.9
3Display Results57570.0301900.0
 (SQL Overall)178691576.20328807.2
 
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.