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

56 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
osteoma94543(None) 
osteomas1045331osteomas
osteoid848192osteoid
osteomata1144142osteomata
ostomy1137832ost_omy
stemma10328132_stemma
stoma75918272_st_oma
stroma84313072_stroma
asteria7316183asteria
asthma11126563ast_hma
caeoma1039033_caeoma
esteem838813esteem_
esteems935243esteems
oedema936573oede_ma
optima10106533opt_ima
osetra667423os_etra
osseous736063osseous
ossetra744073ossetra
osteal6312963oste_al
osteoids945953osteoids
osteopath1453713osteopath
osteoses839033osteoses
osteosis846743osteosis
osteotome11134133osteotome
osteotomy14133663osteotomy
ostia52315583ost__ia
ostiolar844583ostiolar
ostiole739013ostiole
ostium8310133ostium_
ostomate1049573ost_omate
ostraca937823ostraca
ostraka1144833ostraka
ottoman946283o_ttoman
outcome11310573outcome
oysterman1443463oysterman
roseola777053ros_eola
rostella845493rostella
smegma1134113_smegma
soma65635293_s__oma
steam76322933_steam_
steams84916903_steams
steamy115112373_steamy
stela54019043_ste_la
stella63612973_stella
stem610628253_ste_m_
stemmas11256973_stemmas
stemmy13417033_stemmy
stems75219953_ste_ms
sterna63712763_sterna
stigma9226763_stigma
stoa45425913_st_o_a
stomal85213313_st_omal
stomas84816323_st_omas
stomp95616663_st_omp
stromal93010593_stromal
struma84313273_struma

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.406440125.6
2DLD Change Limit134027566.59320328.7
3Display Results56560.0134307.7
 (SQL Overall)178691567.01225483.6
 
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.