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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
rumen7441950(None) 
lumen75220901lumen
numen74216791numen
ramen75625191ramen
rumens83611811rumens
acumen1049012acumen
admen84516182admen
amen66733152_amen
axmen145112272axmen
brume95817982brume_
brumes106417072brumes
busmen1039892busmen
cerumen1147762cerumen
cumin94616972cumin
fume96727632fume_
fumed116118822fumed
fumer105918232fumer
fumes105224702fumes
fumet105630222fumet
grume86218162grume_
grumes94415552grumes
gunmen9348722gunmen
human102716032human
hymen13311042hymen
limen75426032limen
lumens85013972lumens
lumpen104010662lumpen
men59252852__men
nomen75621622nomen
omen66828182_omen
premen105017802premen
queen144312062queen
ragmen93712182ragmen
ramee74633852ramee
ramet75743142ramet
raven84723442raven
reman75730152reman
remend95216552remend
remet74843722remet
remex146315792remex
rime65138882rime_
rimed84826372rimed
rimer75429242rimer
rimes75634542rimes
ripen75619262ripen
risen54621882risen
riven85121622riven
rodmen939712rodmen
roman75424822roman
romeo73719702romeo
rouen54920902rouen
roven85521972roven
rowen84921152rowen
rube65532012rube_
rubel75416832rubel
rubes74928412rubes
rude55632782rude_
ruder65320542ruder
rue35549262ru_e_
rued55729792ru_ed
ruer46127562ru_er
rues46044482ru_es
ruin47430512ru_in
rule49938422rule_
ruled65822522ruled
ruler54923342ruler
rules55234252rules
rum56644642rum__
rumba93612512rumba
rumina83412482rumina
rummer104715482rummer
rummy124212412rummy
rumor71011322rumor
rump86729082rum_p
rumps95922292rumps
rums64833472rum_s
run36244992ru__n
rune45236302rune_
runes55530222runes
rupee7321282rupee
ruse45938932ruse_
ruses56136582ruses
rutin55421342rutin
semen75724102semen
vimen104114752vimen
women104619252women
yamen104115182yamen

Search took 3 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 Filter178691538000.326548131.9
2DLD Change Limit53800871.70331591.3
3Display Results87870.0165437.5
 (SQL Overall)178691872.04587379.5
 
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.