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

97 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
rhombus1424389(None) 
rhombs13336491rhomb_s
kombus1435522_kombus
phoebus1443822phoebus
rhamnus1233132rhamnus
rhomb12399802rhomb__
rhombi13365192rhomb_i
rhombic16264522rhombic
rhombuses1643292rhombuses
rhumbas14305162rhumbas
rhumbs13366772rhumb_s
thrombus1543612thrombus
bombes124916823_bombes
bombs115818823_bomb_s
chimbs153910303chimb_s
chomps155112223chom_ps
chorus115014763cho_rus
chromous15258333chromous
chymous1775693chymous
combes125321733_combes
combos125316613_combos
combs116122963_comb_s
combust1338353_combust
comous10816503_comous
coombes133810663coombes
coombs124210193coomb_s
dhobis1236103dho_bis
glomus9468093glom_us
gombos114311093_gombos
habus106317143_h_abus
hobos106321353_ho_bos
hobs97038983_ho_b_s
hocus104715203_ho_cus
hombre13309303_hombre
hombres14369873_hombres
homburg1543073_homburg
homburgs1642733_homburgs
homers114821973_homers
homes106938813_hom_es
homeys145012873_homeys
homies114524723_homies
hommos13128503_hommos
homos105921783_hom_os
humbug1434803_humbug
humbugs1534243_humbugs
hummus1336243_hummus
humus106215073_hum_us
iambus10468903_iambus
kombu1347243_kombu_
limbus105710383_limbus
momus96116113_mom_us
nimbus10377283_nimbus
phoebes1435813phoebes
railbus934413railbus
ramous8417103r_amous
ramus76418283r_am_us
rebus75721113r__ebus
recombs1336753recomb_s
rhemes115913183rhem_es
rhesus936203rh_esus
rhodium1345333rhodium
rhodiums1443763rhodiums
rhomboid1643843rhomboid
rhomboids1742833rhomboids
rhonchus1642053rhonchus
rhos76319063rho___s
rhumb12438653rhumb__
rhumba13375553rhumb_a
rhus75114053rh___us
rhymers15365543rhymers
rhymes14419823rhym_es
rimous8311913r_imous
riotous739863riotous
robes75133303r_o_bes
robs65837873r_o_b_s
robust8310433r_o_bust
romans84620243r_omans
romeos84013173r_omeos
romps94617543r_om_ps
roms67038963r_om__s
roomers95416413roomers
roomful1244183roomful
roomfuls1342823roomfuls
roomies93017243roomies
rooms75324683room__s
rubus76415053r__ubus
rumbas102512013r_umbas
rumpus10458893r_umpus
shamus114112813sham_us
shoyus1265993sho_yus
thous86017253tho__us
thumbs13377443thumb_s
thymus14324733thym_us
tombs97818733_tomb_s
whomps16457603whom_ps
wombs125813343_womb_s
zombis1936283_zombis

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.1561145455.1
2DLD Change Limit134027976.54620474.6
3Display Results97970.0332939.4
 (SQL Overall)178691976.73526531.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.