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

169 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
zein13562060(None) 
pein65834941pein
rein46040891rein
vein75625751vein
zeins144715391zeins
zin125643771z_in
aeon45634612aeon
agin56132712agin
ain37579092_ain
akin86328032akin
amin66042252amin
ayin76331742ayin
bean66443862bean
been65335782been
begin85117352begin
being84920502being
ben56554922be_n
bin56658642_bin
blin67228172blin
brin67038192brin
cain65643912cain
ceil65725062ceil
chin96934742chin
coin66645352coin
dean56039482dean
deign74312802deign
deil56231622deil
den47554342de_n
deni56929392deni
din46459462_din
djin12911632djin
en28052392_e_n
eon36052082_eon
ern35738362_ern
fain75840562fain
feign94210712feign
feint84732252feint
fen66851352fe_n
fern76129322fern
fin66458032_fin
foin77231562foin
gain56042162gain
gen45950512ge_n
gien56330022gien
gin46055752_gin
grin55733722grin
heil76328932heil
heir77523802heir
hemin103620932hemin
hen67555272he_n
hern76134892hern
hewn106719852hewn
hin67559562_hin
in28150862__in
jean116629282jean
jeon116821442jeon
jin106443932_jin
join116724832join
kain85334292kain
keen84830412keen
keir86217872keir
ken76343982ke_n
kern85326212kern
kin76353972_kin
lain46146282lain
lean46345242lean
lei36846382lei_
leis45739602leis
levin84816412levin
lien45339802lien
lin37967372_lin
loin46838722loin
main65345522main
mean65538092mean
meiny104015412meiny
men59252852me_n
mien65028362mien
neif75429492neif
neon47026422neon
olein5316002olein
pain65647242pain
pean66147172pean
peen65938082peen
peins76128062peins
pekin111514422pekin
pen56558842pe_n
peon65635242peon
pin57066722_pin
pyin96823232pyin
quin135823922quin
rain46251732rain
rei35647252rei_
reif76937652reif
reign65015192reign
reink95518092reink
reins56234562reins
reis45343232reis
renin54830032renin
repin75324702repin
resin54131052resin
rewin85623962rewin
rin36663182_rin
ruin47430512ruin
sain45551292sain
seen46943122seen
sei36048932sei_
seif75638732seif
seine55732872seine
seis45542392seis
sen36058522se_n
serin55434442serin
sewn76124332sewn
shin75634312shin
sin36265892_sin
skein94814412skein
skin85927532skin
spin66231302spin
stein54620542stein
tain45548072tain
teen45938202teen
teind6213612teind
ten35856112te_n
tern46134802tern
thein85919022thein
thin76732392thin
tin36362172_tin
twin76023082twin
tyin76424002tyin
vain75233002vain
veil75523592veil
veins84620492veins
veiny115414362veiny
venin85118662venin
wain75840202wain
wean75734352wean
ween75835462ween
weir76019922weir
wen66249602we_n
whin105225692whin
win66456292_win
yean75834582yean
yen66847382ye_n
yin67648732_yin
zayin174512042zayin
zeal135530332zeal
zeatin15412822zeatin
zebu153414722zebu
zechin20137702zechin
zed135431172ze_d
zeds145821802zeds
zee126143232ze_e
zees136331892zees
zek167323162ze_k
zeks175815062zeks
zep147129142ze_p
zeps156019342zeps
zerk175319252zerk
zero134822472zero
zest136035702zest
zeta135121642zeta
zig136931902z_ig
zinc156819092z_inc
zine137036152z_ine
zing145728612z_ing
zins135735002z_ins
zip146636222z_ip
zit126049992z_it
zoic152316072zoic
zoon137326982zoon

Search took 2 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 Filter178691298720.283631417.0
2DLD Change Limit298721690.82636164.6
3Display Results1691690.0463673.9
 (SQL Overall)1786911691.155154710.8
 
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.