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

152 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
saurians83776(None) 
saurian739911saurian_
durians839572_durians
pagurians1243392pagurians
parians93519732pa_rians
salpians1036762salpians
sarans64224432sa_r_ans
sarins63932622sa_ri_ns
sauries72821622sauri_es
aerials74017553_aerials
agrias74315393_agria_s
anurans73810553anur_ans
anurias7312253anuria_s
aquarians1845873aquarians
arias55438023_a_ria_s
auras55932553_aur_a_s
auris55331533_auri__s
aurists74615783_aurists
auxins13129813_auxi_ns
avians93711563_a_vians
banians9312033ba_nians
burans85019303_bur_ans
burials93612083_burials
burins84221893_buri_ns
carinas93622403ca_rinas
carrions10312453carrions
cautions103313183cautions
cesarians1146363cesa_rians
courlans10117613courlans
crucians1245293crucians
currans9310613_currans
cyprians1544213cyprians
durian7312003_durian_
durions839963_durions
farinas103215233fa_rinas
furans94515953_fur_ans
guardians1143913guardians
hariana10310243ha_riana
harianas1139163ha_rianas
harijans1845723ha_rijans
harridans13154563harridans
jarinas143712183ja_rinas
kalians11310183ka_lians
kauries113613193kauri_es
kauris103611533kauri__s
kurgans12145653_kurgans
lariats7615053la_riats
larrigans1044013larrigans
latrias71913213latria_s
lauans65113533lau__ans
lauras63414333laur_a_s
lurdans837073_lurdans
magians10310753ma_gians
marinas93519383ma_rinas
martians103111613martians
pagurian1144613pagurian_
paphians1545593paphians
pariahs123812343pa_riahs
parian83223963pa_rian_
partans94418283pa_rtans
paulins9312613pauli_ns
purins83722653_puri_ns
puritans1037633_puritans
pyurias1236713pyuria_s
quartans1736283quartans
radians83013823ra_dians
rosarians945793rosa_rians
sabins85521983sa_bi_ns
sabras85116363sabr_a_s
sabring102614843sabri_ng
sacrals93311793sacr_als
sacring103115983sacri_ng
sacrings11278923sacrings
sacristans1243073sacristans
sacrists1039563sacrists
sadirons936023sadirons
saimins9312113saimi_ns
sains55639973sa__i_ns
salariats947823salariats
salinas73116093sa_linas
salpian938493salpian_
saltpans1034813saltpans
salvias10279933salvia_s
samaritans1242933samaritans
sampans112411003sa_mpans
samurais1046143samur_ais
sangrias938373sangria_s
sapiens9310173sa_piens
saran53730303sa_r_an_
sarcinas1039273sarcinas
sardana838643sa_rdana
sardanas937813sa_rdanas
sardars83112903sa_rdars
sarin55239253sa_ri_n_
saris54544953sa_ri__s
sarsars73512143sa_rsars
sarsens7311393sa_rsens
sasins64923103sa_si_ns
satins64930483sa_ti_ns
satraps95011643satr_aps
saturant8410643satur_ant
saturants946383satur_ants
saucepans1342173saucepans
sauciers1076733sauciers
saucing10311003sauci_ng
saunaing937013saunaing
saunas63915433sau_na_s
saurels749303saur_els
savarins1139893savari_ns
savins93923133sa_vi_ns
seatrains947603seatrains
serials73919743s_erials
serins64029673s_eri_ns
shariahs14206393shariahs
sharias102516003sharia_s
shorans102812413shor_ans
silurian846293silurian_
simians959203s_imians
slurban944863slurban_
soudans8309353sou_dans
souring83219063souri_ng
sovrans1036483sovr_ans
sporrans1045523sporrans
sprains93013593s_prains
spurious1036963spurious
spurns84811383spur__ns
strains74218153s_trains
suasions838783suasions
suburbans1344093suburbans
suldans8299723s_uldans
sultans72411833s_ultans
suntans72111733s_untans
surahs94515543s_ur_ahs
suras55336323s_ur_a_s
surimis938843s_urimis
surpass938283s_urpass
surras65919533s_urra_s
tarpans92513533ta_rpans
tartans72615823ta_rtans
tarzans16329923ta_rzans
taurine7311363tauri_ne
taurines8310553taurines
therians1138313therians
tsarinas835273tsa_rinas
turbans939563_turbans
turions7311573_turions
urials64415193__urials
valerians1245343valerians
variant10316803va_riant
variants1139203va_riants
varias95019903va_ria_s
yautias1046333yautia_s

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621527.40619735.6
3Display Results1521520.0463304.3
 (SQL Overall)1786911527.87222699.6
 
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.