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

68 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
joram14581698(None) 
foram105124931foram
jorams154810531jorams
jorum145513741jorum
bora66141632bora_
boral75831702boral
boras75938302boras
borax145918722borax
coral76033452coral
corm85735382cor_m
cram85635492_cram
diram84419472diram
dorm76834632dor_m
dram75832002_dram
foam97127172fo_am
fora75937392fora_
forams115115912forams
foray115023972foray
form95836872for_m
forum108318762forum
goral65125752goral
gorm75529392gor_m
gram77034582_gram
hora76136562hora_
horah117922052horah
horal86328682horal
horas86333102horas
ihram10310182ihram
jam126942522j__am
jordan1468062jordan
jorums15408092jorums
jota116423622jota_
jotas125717442jotas
joual12311652joual
jowar155211432jowar
jura116024892jura_
jural125120482jural
jurat124829322jurat
kora86431552kora_
korai97018522korai
koras95927112koras
korat94934432korat
korma115913072korma
loam65630482lo_am
loral55927822loral
loran55925092loran
mora66641272mora_
morae75831192morae
moral75533432moral
moras76438782moras
moray105423792moray
norm66429812nor_m
ogam75120032_ogam
ora37250832_ora_
orad56031692_orad
oral47638122_oral
pram85733492_pram
ram56867272__ram
roam67132412ro_am
scram910621622scram
sora45746912sora_
soras55041012soras
tora47545992tora_
torah87125272torah
toras55540372toras
tram67034552_tram
worm96129492wor_m
ziram163912892ziram

Search took 4 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.606294869.6
2DLD Change Limit53800682.87618706.5
3Display Results68680.0461478.3
 (SQL Overall)178691683.52850649.4
 
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.