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

114 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
layin8472033(None) 
ayin76331741_ayin
lain46146281la_in
lapin75222921lapin
laying104525701laying
layins93817651layins
zayin174512041zayin
agin56132712_agin
ain37579092_a_in
akin86328032_akin
alanin6317272alanin
algin65718762algin
aloin55227422aloin
amin66042252_amin
ayins85321612_ayins
basin75026922basin
baying125222582baying
blain75421792bla_in
cabin94820942cabin
cain65643912ca_in
claying133614302claying
elain55324702ela_in
fagin9216572fagin
fain75840562fa_in
faying134521072faying
flavin1239302flavin
flaying143914462flaying
gain56042162ga_in
gamin84423002gamin
haying134420612haying
kain85334292ka_in
labia75219012labia
lacing94626232lacing
laden65022192laden
lading84227122lading
ladino73615122ladino
ladykin1543962ladykin
lagan66520342lagan
laic65931562la_ic
laid56439142la_id
lair45934152la_ir
laking115027042laking
lamia75324322lamia
lamina84920442lamina
laming94528362laming
lapins84520682lapins
lapis76223152lapis
lari45839152lari_
larine63927042larine
laris54737462laris
lasing74727982lasing
laten54328342laten
lati46438272lati_
latina65621142latina
latino64120472latino
lattin64316222lattin
lauan55216792lauan
laving104623572laving
lawine93316462lawine
lawing104625282lawing
lawn75925632la_wn
lay68865352lay__
layed95127382layed
layer84626472layer
layman113511302layman
laymen113010842laymen
lays76043252lay_s
layup1037722layup
lazing164821472lazing
lazying2046672lazying
levin84816412levin
lin37967372l__in
linin58025522linin
lipin75518892lipin
login66025002login
loin46838722l_oin
lupin75215842lupin
lying95717452l_ying
lysin84512782lysin
main65345522ma_in
matin75132852matin
mavin105722952mavin
mayan105616902mayan
maying124421152maying
mayvin1436522mayvin
pain65647242pa_in
patin76832852patin
pavin105623202pavin
paying123722162paying
plain74823302pla_in
playing133816092playing
pyin96823232_pyin
rain46251732ra_in
ravin85624652ravin
rawin85521472rawin
raying105027192raying
rayon83815702rayon
sabin74924952sabin
sain45551292sa_in
sarin55239252sarin
sasin54626572sasin
satin55935222satin
savin84625082savin
sayid95516722sayid
saying104325542saying
slain54923572sla_in
slaying113316842slaying
tain45548072ta_in
takin94921302takin
tyin76424002_tyin
vain75233002va_in
wain75840202wa_in
yin67648732__yin
zayins18409712zayins

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.296603685.8
2DLD Change Limit538001141.84329191.5
3Display Results1141140.0333454.5
 (SQL Overall)1786911142.17282270.3
 
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.