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

59 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
bohemia144636(None) 
bohemian1544761bohemian
bohemias1545981bohemias
bohea105013732bohe__a
bohemians1643442bohemians
coremia11310362coremia
toxemia1644872toxemia
anaemia959803anaemia
anemia82613573_anemia
anoxemia1754773anoxemia
anthemia1349193anthemia
aphelia1249423aphelia
azotemia19104173azotemia
babesia1146623babesia
bema85825253b__em_a
bemix165011453b__emix
biochemic2044633biochemic
boccia12338793bo_ccia
bodega1034933bode_ga
boehmite1583153boehmite
boheas114013213bohe_as
boleti8413403boleti_
bolivia1246063bolivia
bonemeal1245163bonemeal
bonhomie1555213bonhomie
borrelia1044553borrelia
bothria1246443bothria
bulimia1145043bulimia
bumelia1145263bumelia
chemic153012093_chemic
codeia94112193code_ia
coheir1137583cohe_ir
copremia1445253copremia
godetia945353godetia
hemic125718623__hemic
hemin103620933__hemin
hyphemia2146133hyphemia
ischemia1544073ischemia
lithemia1345253lithemia
lobelia947213lobelia
mohelim1444763mohelim
obelia8329453_obelia
ohia75719363_oh__ia
ohmic1237833_oh_mic
polemic13311253polemic
pyaemia1445733pyaemia
pyemia1337553_pyemia
schema1388373schem_a
sthenia1058503sthenia
tonemic11310173tonemic
totemic1137533totemic
toxaemia1743063toxaemia
toxemias1744733toxemias
toxemic1845593toxemic
uraemia946503uraemia
uremia82910893_uremia
viremia1246083viremia
zoecia1735553zo_ecia
zooecia1843843zooecia

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 Limit134027595.78323176.0
3Display Results59590.0134538.5
 (SQL Overall)178691596.20228811.8
 
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.