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

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

126 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
loran5592509(None) 
loan47436451lo_an
logan68123281logan
loral55927821loral
lorans65117601lorans
lorn46435251lor_n
bogan87519002bogan
bora66141632bora_
boral75831702boral
borane84620212borane
boras75938302boras
borax145918722borax
born67338412bor_n
boron76727142boron
bran65740382_bran
buran75225302buran
coral76033452coral
corban10314692corban
corn69945812cor_n
cotan71521782cotan
flora85317102flora_
florae94713882florae
floral94313812floral
floras94715692floras
florin9312652florin
fora75937392fora_
foram105124932foram
foray115023972foray
furan84320012furan
goban84414072goban
goral65125752goral
gowan95415742gowan
gran56335012_gran
groan65618422groan
hogan97817702hogan
honan85319772honan
hora76136562hora_
horah117922052horah
horal86328682horal
horas86333102horas
horn76735612hor_n
joram145816982joram
jordan1468062jordan
koan85425032ko_an
kora86431552kora_
korai97018522korai
koras95927112koras
korat94934432korat
korun9411922korun
lagan66520342lagan
lauan55216792lauan
lean46345242l_ean
learn55322662learn
leman75622602leman
ligan67920282ligan
liman75921602liman
lira46928682lira_
liras56021982liras
load56730602lo_ad
loaf76734902lo_af
loam65630482lo_am
loans56026462lo_ans
lobar7313012lobar
loca65527682loca_
local74820272local
lochan1139092lochan
loden66621142loden
logans76319062logans
login66025002login
logon615922312logon
loin46838722lo_in
longan75612362longan
loon47344792lo_on
lord55032082lor_d
lords64923502lords
lore45850352lor_e
loreal63814312loreal
lores55045402lores
loris55329152loris
lorry86315672lorry
lory75931712lor_y
lota47233502lota_
lotah85315852lotah
lotas55926302lotas
lovat8321042lovat
lown76929292lo_wn
loyal84513482loyal
lurdan738362lurdan
moan65832022mo_an
mora66641272mora_
morae75831192morae
moral75533432moral
moras76438782moras
moray105423792moray
morgan9311372morgan
morn66237562mor_n
moron76925422moron
ora37250832_ora_
orad56031692_orad
oral47638122_oral
orang65119942_orang
organ6915392_organ
porn65636022por_n
pyran10514472pyran
ran38266622__ran
reran57329102reran
roan47234202ro_an
roman75424822roman
rowan85418732rowan
saran53730302saran
shoran94016042shoran
slogan7539222slogan
solan55328152solan
soman75024902soman
sora45746912sora_
soras55041012soras
sorn46641062sor_n
sovran937152sovran
tolan55124012tolan
toman75724052toman
tora47545992tora_
torah87125272torah
toras55540372toras
torn46044252tor_n
woman105818002woman
worn75631752wor_n

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.610292936.1
2DLD Change Limit538001262.97018114.5
3Display Results1261260.0304200.0
 (SQL Overall)1786911263.61049498.9
 
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.