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

176 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
osseins73613(None) 
ossein636591ossein_
caseins93115052caseins
essoins737602essoins
isseis638562issei_s
oleins6313522o_leins
opsins8411712ops_ins
orceins937742orceins
osseous736052osseous
skeins103911902_skeins
steins64818342_steins
abseils935973abseils
arshins10312573arshins
aspens85013353aspe_ns
assails769093assails
assais6711963assai_s
assent65119953asse_nt
assents74512223assents
asserts74311793asserts
asses55629283asse__s
assess65710463asse_ss
assets65617663asse_ts
assigns836193assigns
assoils776663assoils
basins85722763bas_ins
bosses85925403bosse__s
bossies94116833boss_ies
bossing103714603boss_ing
buskins133310943buskins
casein83216453casein_
caserns94711223caserns
codeins103715483codeins
cosseting1239543cosseting
cossets95014283cosse_ts
cousins9516003cous_ins
cowskins1745263cowskins
cysteins1355733cysteins
deveins1138803deveins
doeskins1344903doeskins
dossels85511603dosse_ls
dossers84516233dosse_rs
dosses76126273dosse__s
dossiers9318043dossiers
dossils8669773doss_ils
dossing93313273doss_ing
dyneins1134213dyneins
eisweins1143383eisweins
eosins64419163eos_ins
esses56422973esse__s
essoin638193essoin_
estrins7315853estrins
fadeins1168503fadeins
fosses96022083fosse__s
fossils10379013foss_ils
foxskins2242883foxskins
fusains1038363fusains
gaskins123510773gaskins
gossans836783goss_ans
gossips1035903goss_ips
gossoons944893gossoons
holsteins1245263holsteins
hordeins1238323hordeins
isatins7310773isatins
isospins1044223isospins
issei568573issei__
issuing836053issuing
jasmins1637083jasmins
josses135117683josse__s
lashins103915153lashins
lessens7409383lesse_ns
lomeins969473lomeins
loosens716310953loose_ns
losses65925233losse__s
luteins7310103luteins
lysins94610953lys_ins
mossers94116193mosse_rs
mosses85527683mosse__s
mossing103915423moss_ing
mureins9310733mureins
muslins9312213muslins
niseis63512023nisei_s
oases55330983oase__s
oasis56422553oas_i_s
obsess845943obse_ss
obtains939163obtains
oceans81211003o_ceans
odeons739023o_deons
oestrins8312673oestrins
oilskins1243873oilskins
olefins1037493olefins
olein5316003o_lein_
oleine6313793o_leine
oleines7313393o_leines
omens75618963o_me_ns
onsets64013543onse_ts
oodlins83210513oodlins
opens76118553o_pe_ns
opsin7613473ops_in_
opsonins1045533opsonins
orcein838183orcein_
orcins83313433o_rcins
ordains879653ordains
origins8310463origins
orpins83614163o_rpins
oscine8311563o_scine
oscines9310363o_scines
oses46641513o_se__s
osiers63412793osie_rs
osmics1036463o_smics
ossetra744073ossetra
ossetras844083ossetras
ossia53710403oss_i_a
ossifies1177563ossifies
ossify1244973oss_ify
osteitis847013osteitis
osteoids945953osteoids
ousels64815273ouse_ls
ousting84021353ousting
outsins73417863outsins
ovens86217453o_ve_ns
owsen84210193owse_n_
peins76128063__peins
posses85128803posse__s
possess9419123posse_ss
possets94212773posse_ts
posteens10309733posteens
posterns102713723posterns
postins93721203postins
reins56234563__reins
resins64528773res_ins
rosins64521863ros_ins
sabins85521983_sabins
sains55639973__sains
sarins63932623_sarins
sasins64923103_sasins
satins64930483_satins
savins93923133_savins
seeing74222143_seeing
seeings84411293_seeings
seifs85019333__seifs
seine55732873__seine
seines65029903__seines
seis45542393__sei_s
sereins73716113sereins
serins64029673_serins
sheens95116993_sheens
sheiks132510013_sheiks
shins85131043__shins
sins46755273__s_ins
siskins1159583siskins
skeans104512913_skeans
skeens103912913_skeens
skein94814413_skein_
skins94723463__skins
sowens93613153sowe_ns
sozins15510793_sozins
speans85417143_speans
speils84116223_speils
speirs85013233_speirs
speiss84311643_speiss
spins75327983__spins
stains64923653_stains
stein54620543_stein_
sterns64616763_sterns
swains94513953_swains
tameins9311413tameins
theins95015423_theins
tocsins939963tocs_ins
topspins1244873topspins
tossers74713503tosse_rs
tosses65225393tosse__s
tossing83612563toss_ing
veins84620493__veins
viseing11299163viseing
worsens104610263worse_ns
zeins144715393__zeins

Search took 7 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.436409841.7
2DLD Change Limit1340271766.03322215.6
3Display Results1761760.0632793.7
 (SQL Overall)1786911766.53227356.2
 
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.