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

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
scram910621611scram
sura45740291sura_
surah86823251surah
sural55931261sural
suras55336321suras
ashram1139052ashram
aura45836252aura_
aurae54128112aurae
aural54428962aural
aurar54420252aurar
auras55932552auras
aurum7614962aurum
bura66139532bura_
buran75225302buran
buras74736292buras
cram85635492_cram
diram84419472diram
dram75832002_dram
dunam8313732dunam
dura55232112dura_
dural64923892dural
duras65727722duras
durum8513202durum
foram105124932foram
furan84320012furan
gram77034582_gram
ihram10310182ihram
joram145816982joram
jura116024892jura_
jural125120482jural
jurat124829322jurat
mura65633292mura_
mural75225102mural
muras75329562muras
pram85733492_pram
ram56867272__ram
rural55821172rural
saran53730302saran
scam85932352s_cam
scrag85916172scrag
scrams105216622scrams
scrap97120402scrap
scream104814242scream
scrim95419722scrim
scrum95418192scrum
seam66645972s_eam
sera46141392sera_
serac75925202serac
serai56830162serai
seral56336382seral
serum75223472serum
sham96436352s_ham
slam67737972s_lam
smarm95517602smarm
sora45746912sora_
soras55041012soras
spam85930042s_pam
sprag86418692sprag
sprat76635972sprat
spray106720062spray
steam76322922steam
strap77925262strap
straw813321292straw
stray88525572stray
stream84717282stream
strum75619442strum
suba64926602suba_
subah106015212subah
subas74724072subas
sugar6312912sugar
sum56346012su__m
sumac99514882sumac
summa94713312summa
sunray9310122sunray
supra73614252supra_
surahs94515542surahs
surd56433812sur_d
surds65624662surds
sure45447412sur_e
surer54833092surer
surf76039312sur_f
surfs85022542surfs
surfy115319472surfy
surge65027692surge
surgy95118522surgy
surimi839102surimi
surly85124422surly
surname937602surname
surra55521342surra
surras65919532surras
surtax1337842surtax
sutra54217932sutra_
sutras64818582sutras
swam96329982s_wam
swarm106218832swarm
tram67034552_tram
ziram163912892ziram

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.0931921408.6
2DLD Change Limit53800971.94027732.0
3Display Results97970.0303233.3
 (SQL Overall)178691972.06386617.1
 
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.