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

217 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
laic6593156(None) 
lac510155821la_c
laich105920711laich
laics76419251laics
laid56439141laid
lain46146281lain
lair45934151lair
ai211288392_ai_
aid49269072_aid
ail37171042_ail
aim57858212_aim
ain37579092_ain
air38058392_air
ais39083572_ais
ait38093902_ait
alcaic1039982alcaic
alec66430062alec
alif76242132alif
alit46155692alit
arc510250902_arc
bail65042802bail
bait66556002bait
baric96125692baric
basic96220522basic
blain75421792blain
caid77837532caid
cain65643912cain
chic115925202chic
claim95616912claim
dais57040702dais
daric85623112daric
elain55324702elain
emic86422742emic
epic86921302epic
etic66123952etic
fail74840242fail
fain75840562fain
fair76332522fair
flail85316182flail
flair86114122flair
flic96223732flic
gain56042162gain
gait56150192gait
gamic103916192gamic
glair65313552glair
haik115526982haik
hail74839062hail
hair76330142hair
hic86540562_hic
huic94818052huic
iliac75013482iliac
jail115529092jail
kaif116933922kaif
kail85131492kail
kain85334292kain
la219261632la__
lab58864782la_b
labia75219002labia
labs67145122labs
lace66848472lace
lack105837682lack
lacs66942482lacs
lactic10713492lactic
lacy95829632lacy
lad48165702la_d
lade56345982lade
lads56549132lads
lady86527152lady
lag47862122la_g
lags56546222lags
laical8312322laical
laichs115110892laichs
laigh95515922laigh
laird65417792laird
lairs55425872lairs
laith85722102laith
laity85318902laity
lake85741602lake
lakh114919952lakh
laky116725822laky
lall45531312lall
lam57666712la_m
lama66635292lama
lamb86832142lamb
lame66849292lame
lamia75324322lamia
lamp86233822lamp
lams66552262lams
lance75126722lance
land56337302land
lane45153322lane
lang56637372lang
lank84734442lank
lap58565272la_p
lapin75222922lapin
lapis76223152lapis
laps66848872laps
lar37967532la_r
larch105919792larch
lard56742002lard
lari45839152lari
laris54737462laris
lark85733862lark
lars46956572lars
las37281472la_s
lase46148512lase
lash76539652lash
lass47444542lass
last46260322last
lat37593402la_t
latch104620462latch
late47560482late
lath76640382lath
lati46438272lati
lats45962702lats
latu47934182latu
laud56527722laud
lav66847342la_v
lava76725422lava
lave75642142lave
lavs76734152lavs
law68656642la_w
lawn75925632lawn
laws76441682laws
lax107651522la_x
lay68865352la_y
layin84720332layin
lays76043252lays
laze136235052laze
lazy166423072lazy
lei36846382lei_
leis45739602leis
li29948752l_i_
liar47229682liar
lib57750262l_ib
lice66045062l_ice
lich96230842l_ich
lick106935072l_ick
lid47453512l_id
lie38264522l_ie
lin37967372l_in
lip514755802l_ip
lis37162272l_is
lit39377312l_it
loci66126282loci
logic88217832logic
loid55531482loid
loin46838722loin
lotic76420662lotic
ludic82912802ludic
lyric104512722lyric
lytic104513032lytic
mac78053922ma_c
mafic125615462mafic
magic105818652magic
maid75537632maid
mail65543432mail
maim85831472maim
main65345502main
mair66133762mair
malic94525652malic
manic94629432manic
marc87034622marc
mic77647632_mic
naif76839012naif
nail45838652nail
narc67127952narc
naric76824172naric
odic74920572odic
oleic7313332oleic
otic66624812otic
pac79054082pa_c
paid75737482paid
paik105726802paik
pail66141832pail
pain65647242pain
pair66031512pair
panic93923902panic
pic76046822_pic
plaice10311552plaice
plaid85118302plaid
plain74823302plain
plait75631572plait
pyic116915822pyic
qaid146023842qaid
rabic93817392rabic
rai37658222rai_
raia46638382raia
raid55243072raid
rail46147762rail
rain46251732rain
rais45252622rais
sac57452862sa_c
saice75424052saice
said55742112said
sail45447162sail
sain45551292sain
salic73424712salic
sic55847872_sic
slain54923572slain
spic85227432spic
tail45443652tail
tain45548072tain
talc66226812talc
tic56343462_tic
uric63624932uric
vac86537142va_c
vail75432552vail
vain75233002vain
vair75624142vair
vatic10316422vatic
waif105836742waif
wail75238822wail
wain75840192wain
wair75830052wair
wait75553692wait
zoic152316072zoic

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.0931921408.6
2DLD Change Limit298722170.97030795.9
3Display Results2172170.0464717.4
 (SQL Overall)1786912171.109161128.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.