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

193 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
lineups93491(None) 
lineup835981lineup_
linkups1333631linkups
lieus56218482li_eu_s
linecuts1094552linecuts
linens64818392line_ns
liners65428852line_rs
lines57054572line__s
linkup1245122linkup_
linums838282lin_ums
pileups11365432pileups
pinups1037412pin_ups
tuneups933332tuneups
windups1334782windups
aeneus61111143aeneu_s
aliners74717723aline_rs
alines65735223aline__s
biceps12447713bice_ps
biners85023633bine_rs
bines76946793bine__s
cinemas1138043cinemas
cineols9128853cineols
cines75239683cine__s
cinques1837333cinques
clines84926043cline__s
closeups12102803closeups
dineros83812333dineros
diners75525953dine_rs
dines66449153dine__s
dingus83611843dingu_s
dinkums1433673dinkums
diseurs839403diseurs
fines86644263fine__s
flaneurs1133953flaneurs
flareups1342473flareups
hangups1364813hangups
hiccups1643223hiccups
ileus54616893_ileu_s
incurs83012283_incurs
incus73315053_incu_s
indues73515263_indues
inept73622153_ine_pt
inerts64517023_inerts
inputs837703_inputs
inruns6359513_inruns
kickups1443503kickups
kinemas1336893kinemas
kines95039133kine__s
kineses113111253kineses
kinesis11259593kinesis
kingcups1742063kingcups
lanes54946793lane__s
langues81211913langues
langurs889103langurs
larrups934733larrups
layups1133993l_ayups
leaps75522933l__eaps
lenes54738523lene__s
letups8317683l_etups
leuds66214813l__euds
lianes63819323liane__s
libels85112693libe_ls
libers84721443libe_rs
lieges74113443li_eges
liens56525503li_e_ns
liers55130403li_e_rs
lies46454193li_e__s
lieu46534363li_eu__
lifers95617843life_rs
ligers75022043lige_rs
ligneous945233ligneous
likens105613703like_ns
likers104620913like_rs
likes96231903like__s
limbus105710383limbu_s
limens84618033lime_ns
limes75636503lime__s
limeys11429273lime_ys
limners93311563limne_rs
limps95522673li__mps
linacs8310813lin_acs
linages8813173linages
lindens839413lindens
lindies8416583lindies
line46965573line___
lineage878983lineage
lineages979183lineages
lineal65616023line_al
linear65113343line_ar
lineate7815153lineate
linecut997983linecut
lined64934643line__d
lineless82711943lineless
lineman939123lineman
linemen938633linemen
linen55728723line__n
lineny94011443line_ny
liner55938923line__r
liney87029633line__y
lingams104510193lingams
lingas75116573lin_gas
lingers84223303lingers
lingoes84014693lingoes
lings67135773lin__gs
lingua7509913lingu_a
linguae8398413linguae
lingual8379083lingual
linguals9317223linguals
linguisa944473linguisa
linguist948573linguist
lingula8428803lingula
linings84313073linings
linins65922143lin_ins
linkers114317713linkers
links96430193lin__ks
linnets739833linnets
linns56123333lin__ns
linocuts1094573linocuts
linoleums1141943linoleums
linos55631503lin__os
lins47059053lin___s
linseeds944733linseeds
linseys1035083linseys
lintels73311163lintels
linters73822633linters
lintols7339553lintols
lints57137193lin__ts
linum7313823lin_u_m
lioness739103lione_ss
lips67141443li___ps
liqueurs1742413liqueurs
lisps76913913li__sps
liters65429883lite_rs
lithops12307253lithops
litmus836323litmu_s
livens94314893live_ns
livers94927823live_rs
lives86133193live__s
lockups1534243lockups
loners64225813lone_rs
lookups1332953lookups
loups75319623l__oups
lunes55337773lune__s
lunets66914763lune_ts
lyceums1442403lyceums
makeups1533603makeups
miners84126633mine_rs
mines75651953mine__s
miniums113910223miniums
minuets9259853minuets
minus75223933min_u_s
mixups1743263mi_xups
neaps75618323__neaps
neeps75617883__neeps
neuks96510863__neuks
neums75414253__neums
nines55937343nine__s
oilcups1143333oilcups
pickups1754253pickups
pileup10437923pileup_
pileus84514943pileu_s
pineals93212843pineals
pinenes93416673pinenes
pines76048863pine__s
pinesaps1253983pinesaps
pinup9612883pin_up_
sannups934463sannups
sendups10115193sendups
sieurs659043si_eurs
sines55954823sine__s
sinews94210623sine_ws
sinus55523853sin_u_s
sirups83710533si_rups
situps8538783si_tups
slipups1133193sli_pups
sneaps84510863_sneaps
sunups837263sun_ups
takeups1333403takeups
tineas64616483tine_as
tineids8337873tineids
tines54848423tine__s
tinfuls1036593tinfuls
tittups933353tittups
tuneup835203tuneup_
vines85137643vine__s
vinous93914173vinou_s
wikiups16132083wikiups
windup1235383windup_
wines85546863wine__s
winesaps1364553winesaps
winesops1374663winesops
zinebs17606803zine_bs
zines145232653zine__s

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.406440125.6
2DLD Change Limit1340271937.26318453.4
3Display Results1931930.0633063.5
 (SQL Overall)1786911937.73223110.6
 
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.