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

36 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
bulimias125432(None) 
bulimia1145041bulimia_
bulimiac1442651bulimiac
bulimics1443151bulimics
bolivias1345392bolivias
bulimic1345142bulimi_c
abulias93210693abul__ias
bauhinias1443073bauhinias
bimas95521743b__im_as
blimps12588153b_lim_ps
blinis85313683b_lini_s
bohemias1545983bohemias
bolivia1246063bolivia_
bubingas1352803bubingas
bulbils11338333bul_bils
bullies94121893bul_lies
bumelias1245063bumelias
clivias1266693_clivias
culicids1345623culicids
delimits1137573delimits
dulias71212743dul__ias
eulogias946553eulogias
kalimbas1642323kalimbas
kalmias1347973kal_mias
lamias85020613__lamias
limas75627633__lim_as
limbas105313203__limbas
limits82514143__limits
limpas105513083__limpas
militias1048633militias
sublimits1345563sublimits
surimis938843surimi_s
ulamas8910453_ulam_as
ulemas888963_ulem_as
ultimas936363_ultim_as
uremias9249503_uremias

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.423422437.4
2DLD Change Limit146162367.18620339.8
3Display Results36360.000 
 (SQL Overall)178691367.60923484.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.