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

215 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
orceins93774(None) 
orcein838181orcein_
orcins83313431orc_ins
croceins1238102croceins
hordeins1238322hordeins
narceins1036412narceins
oceans81211002o_ceans
oleins6313522o_leins
orchids1377212orchids
orchils1277702orchils
orchis11710772orchi_s
orcin72716572orc_in_
ordains879652ordains
origins8310462origins
orpins83614162or_pins
osseins736132osseins
reins56234562_r_eins
urchins1238862urchins
acetins9313173_acetins
actins86321103_actins
archils12510533archils
archine125817053archine
archines133815253archines
arching136216693arching
archings14499863archings
archons12311583archons
arcing95819643arc_ing
arcking145811963arcking
arcsine94512393arcsine
arcsines104010343arcsines
arctics1138953arctics
arpens84814823arpe_ns
arshins10312573arshins
boreens9310403bor_eens
brains85125473br_ains
brens75823363br_e_ns
brins75533973br__ins
bromins112513783bromins
brucins1158003brucins
bruins86014953br_uins
cains75334303__cains
caseins93115053caseins
ceils75019403__ceils
chins105631463__chins
cocains111313923cocains
cochins141413103cochins
codeins103715483codeins
coins75834553__coins
conceits122813613conceits
concerns122710833concerns
corbeils12358073corbeils
coreigns1136323cor_eigns
cortins92421333cor_tins
cretins93216423cretins
crocein1138073crocein_
croceine1248033croceine
croceines1347733croceines
cyclins1438303cyclins
deceits102810883deceits
decerns10119053decerns
deveins1138803deveins
dormins10311273dor_mins
drains73719403dr_ains
dreeing94311183dreeing
dyneins1134213dyneins
fadeins1168503fadeins
ficins113513983fic_ins
forceps14466983force_ps
forcers124215713force_rs
forces114422133force__s
forcing134013753forc_ing
forfeits1445803forfeits
freeing113713913freeing
gorgerins1145193gorgerins
gorhens1137183gorhe_ns
gradins93416233gradins
grains74223093gr_ains
gratins84119183gratins
greeing93613783greeing
greens75716873gr_eens
grins65427223gr__ins
groins73917203gr_oins
hordein1138753hordein_
lectins92515003lectins
lomeins969473lomeins
lucerns935753lucerns
luteins7310103luteins
moreens939963mor_eens
morgens10310463morge_ns
morphins1538653morphins
mucins102712513muc_ins
mureins9310733mureins
narcein936293narcein_
narceine1046753narceine
narceines1146583narceines
nucleins1046083nucleins
obtains939163obtains
ocean71212963o_cean_
octans81411143o_ctans
odeons739023o_deons
olefins1037493olefins
olein5316003o_lein_
oleine6313793o_leine
oleines7313393o_leines
omens75618963o_me_ns
oodlins83210513oodlins
opens76118553o_pe_ns
opsins8411713o_psins
orating83520323orating
orations81515803orations
orbing93312363or_bing
orbits84211443or_bits
orcas75918623orc__as
orchid1289573orchi_d
orchil1158653orchi_l
orchises1338773orchises
orchitis1346423orchitis
orcinol944703orc_inol
orcinols1044413orc_inols
orcs67025433orc___s
ordain7810403ordain_
ordeals877993ordeals
ordering1039353ordering
orders74315993orde_rs
ordines83014903or_dines
oreads73915773or_eads
oreide7311673or_eide
oreides8312023or_eides
ores46056683or_e__s
organs7912913or_gans
orgeats838353orgeats
orgies72316093or_gies
oribis838833oribi_s
oriels64914623orie_ls
orient6322533orie_nt
orients7311583orients
origans839973origans
origin7311033origin_
orisons7310563orisons
orles55326213orle__s
orlons6411013or_lons
ormers84316143orme_rs
ornis54616773or_ni_s
orphans1237773orphans
orpin73415533or_pin_
orpine83914483or_pine
orpines94414793or_pines
orreries8310123orreries
orris54516553or_ri_s
oscine8311563osc_ine
oscines9310363osc_ines
ossein636593ossein_
ouching134314903ouching
outsins73417863outsins
ovens86217453o_ve_ns
pectins112315233pectins
peins76128063__peins
porcelains1444383porcelains
porcine11312843porc_ine
porcini1137633porc_ini
porcinis1246953porc_inis
porcino1138113porc_ino
precis103416703preci_s
preeing103817673preeing
preens85020113pr_eens
proteins102114283proteins
rains55140233_r_ains
ravins94622563_ravins
rawins95617623_rawins
recits83621353_recits
recoins94019243recoins
recons84922993_recons
reifs84819093_r_eifs
reigns74811753_r_eigns
rein46040893_r_ein_
reink95518093_r_eink
reinks105012153_r_einks
reis45343233_r_ei_s
renins64526453_renins
repins84924313_repins
resins64528773_resins
rewins95020823_rewins
ricins83618703_ricins
rins46153193_r__ins
robbins112811063robbins
robins83617453_robins
rocking143619633rocking
rosins64521863_rosins
rouens64814443roue_ns
rowens94515303rowe_ns
ruins55822033_r_uins
rutins63818393_rutins
screens95212173screens
secerns987733secerns
sereins73716113sereins
skeins103911903_skeins
sorceries1149933sorceries
steins64818343_steins
tameins9311413tameins
theins95015423_theins
tocsins939963tocsins
torching142510083torching
torchons1337503torchons
trains64725343tr_ains
treeing83414303treeing
treens65317873tr_eens
triens65417543trie_ns
tropins93116303tropins
trueing83410183trueing
urchin1138743urchin_
veins84620493__veins
worsens104610263worse_ns
wrens85016243wr_e_ns
zechins21137123zechins
zeins144715393__zeins

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272156.78319759.3
3Display Results2152150.0762828.9
 (SQL Overall)1786912157.01525472.7
 
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.