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 “rhamnus” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
rhamnus123313(None) 
ramous8417112r_amous
ramus76418282r_am_us
rhamnose13103462rhamnose
rhamnuses14102312rhamnuses
rhombus14243892rhombus
shamus114112812sham_us
agamous1037943agamous
alumnus935223alumnus
amus65529613__am_us
anus47131113__a_nus
bhangs12449663bha_ngs
campus125213923_campus
chaines124518733chaines
chains114819703chain_s
chamois143512193chamois
champs154915683cham_ps
chams126028503cham__s
changs125215373cha_ngs
chants115020393cha_nts
chaunts1267083chaunts
chymous1775703chymous
damns84916923_damn_s
dharnas1155373dharnas
famous11412393_famous
grampus12356313grampus
habus106317143_ha_bus
haikus13538293_haikus
haints94417583_haints
hakus125114113_ha_kus
hamals114816833_hamals
hamaul114210873_hamaul
hamauls12387823_hamauls
hames106138703_ham_es
hams96446133_ham__s
hamulus1235323_hamulus
hamzas20119013_hamzas
hands95327383_ha_nds
hangs95726733_ha_ngs
hanks126226863_ha_nks
hants86335403_ha_nts
haunts95614393_haunts
hummus1336243_hummus
humus106215073_hum_us
hymns1337523_hymn_s
iambus10468903_iambus
khans124615173kha_n_s
manus75924933_ma_nus
phallus1236063phallus
radius73914873r_adius
rains55140233r_ain_s
rakus94413673r_a_kus
ramees84620893r_amees
ramets83517393r_amets
ramies84630463r_amies
ramonas9311093r_amonas
ramps96224633r_am_ps
rams65950773r_am__s
rands65930453r_a_nds
ranis55235833r_a_nis
ranks95225733r_a_nks
rants55935343r_a_nts
reamers94221083reamers
reams75729623ream__s
rehangs1137563reha_ngs
remands104914883remands
remans84823003reman_s
rhachis1555693rhachis
rhamnoses14104183rhamnoses
rhaphes1534703rhaphes
rhemes115913183rhem_es
rhesus936203rh_esus
rhinos94411123rh_inos
rhombs13336493rhom_bs
rhumbas14305163rhumbas
rhumbs13366773rhum_bs
rhus75114053rh___us
rhymers15365543rhymers
rhymes14419823rhym_es
ricinus9408123ricinus
rimous8311913r_imous
roamers93713463roamers
roams74919613roam__s
roans54926443roa_n_s
romanos94311483romanos
romans84620243roman_s
ruanas6311263rua_nas
rumpus10458893r_umpus
shamans123610903shamans
shamas113717943sham_as
shames114726223sham_es
shammas14358723shammas
shammes144312833shammes
shammos14307203shammos
shamois123210423shamois
shamos114216983sham_os
shamoys15367283shamoys
shams105829413sham__s
shanks135315583sha_nks
sharns95516983sharn_s
thallus1035603thallus
thanes94918983tha_nes
thanks134313133tha_nks
thymus14324743thym_us
wammus13426733_wammus
wampus13499013_wampus
wamus105514683_wam_us
whams135515643wham__s
whangs13439723wha_ngs
yamuns11336513_yamuns

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.423422437.4
2DLD Change Limit1340271106.14021828.5
3Display Results1101100.0333333.3
 (SQL Overall)1786911106.59627090.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.