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

306 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
lineup83598(None) 
lineups934911lineups
linkup1245121linkup
lieu46534362li_eu_
lieus56218482li_eus
line46965572line__
lineal65616022lineal
linear65113332linear
linecut997982linecut
lined64934642line_d
linen55728722line_n
linens64818392linens
lineny94011432lineny
liner55938912line_r
liners65428842liners
lines57054572line_s
liney87029622line_y
lingua7509902lingua
linkups1333632linkups
linum7313822lin_um
pileup10437922pileup
pinup9612882pin_up
tuneup835202tuneup
windup1235382windup
aeneus61111143aeneus
aline57243153aline__
alined75221403aline_d
aliner65621983aline_r
aliners74717723aliners
alines65735223aline_s
bicep115413543bice_p
bine66650853bine__
biner75930693bine_r
biners85023633biners
bines76946793bine_s
cine66242943cine__
cinema1047643cinema
cineol8108203cineol
cines75239683cine_s
cinque1736853cinque
cline76428533cline__
clines84926043cline_s
closeup11113433closeup
dine55555333dine__
dined76431993dine_d
diner65632903dine_r
dinero75612643dinero
diners75525953diners
dines66449153dine_s
dingus83611843dingus
dinkum1335893dinkum
diseur738843diseur
faceup1334893faceup
fine75147953fine__
fined94930503fine_d
finely123011563finely
finer85431563fine_r
finery124512883finery
fines86644263fine_s
finest94321733finest
flaneur1034183flaneur
flareup1243173flareup
hangup1277293hangup
hiccup1554393hiccup
ileum74512823_ileum
ileus54616893_ileus
incur72212253_incur
incus73315053_incus
indue63516673_indue
inept73622153_inept
inert53234373_inert
input7314653_input
inrun52911373_inrun
kickup1354133kickup
kine85643423kine__
kinema1236013kinema
kines95039133kine_s
kingcup1642473kingcup
lane45153323lane__
lanely93914483lanely
lanes54946793lane_s
langue71012173langue
langur7109303langur
larrup835713larrup
layup1037723l_ayup
leap66032683l__eap
lenes54738523lene_s
letup73712163l_etup
leu36047403l__eu_
leud57223423l__eud
liane54720663liane__
lianes63819323liane_s
libel74116103libe_l
libels85112693libels
liber74723613libe_r
libers84721433libers
lice66045063lice__
lie38264523li_e__
lied55838093li_e_d
lief76036983li_e_f
liege65314433li_ege
lien45339803li_e_n
lienal63912783lienal
liens56525503li_ens
lier45942463li_e_r
liers55130403li_ers
lies46454193li_e_s
lieve86315473li_eve
life75433733life__
lifeful1344613lifeful
lifer85822153life_r
lifers95617843lifers
liger65024463lige_r
ligers75022023ligers
ligneous945223ligneous
like86040843like__
liked104523813like_d
likely13328133likely
liken911818843like_n
likens105613703likens
liker95627063like_r
likers104620913likers
likes96231903like_s
likest104914383likest
limbus105710373limbus
lime66244933lime__
limed85426803lime_d
limen75426033lime_n
limens84618033limens
limes75636503lime_s
limey104721043lime_y
limeys11429273limeys
limned94811473limne_d
limner84112863limne_r
limners93311553limners
limp88432493li__mp
lin37967373lin___
linac7315413lin_ac
linacs8310813linacs
linage7713403linage
linden7411453linden
lindens839413lindens
lindy96918313lin_dy
lineage878983lineage
lineate7815153lineate
linecuts1094553linecuts
lineman939113lineman
linemen938633linemen
ling57447963lin__g
linga66820813lin_ga
lingam95112333lingam
lingas75116563lingas
linger75225993linger
lingers84223293lingers
lingo66022103lin_go
lings67135773lin_gs
linguae8398393linguae
lingual8379073lingual
lingula8428793lingula
lingy96925133lin_gy
linier64423783linier
liniest73321153liniest
linin58025523lin_in
lining74526803lining
linins65922143linins
link86943443lin__k
linked114518213linked
linker104321463linker
linkers114317703linkers
links96430193lin_ks
linky127622383lin_ky
linn46034593lin__n
linnet6419413linnet
linnets739823linnets
linns56123333lin_ns
lino46343373lin__o
linocut997673linocut
linoleum1042263linoleum
linos55631503lin_os
lins47059053lin__s
linseed838203linseed
linsey938983linsey
linseys1035083linseys
lint416266233lin__t
linted74021823linted
lintel64013993lintel
lintels73311163lintels
linter64625333linter
linters73822613linters
lintol6369473lintol
lints57137193lin_ts
linty87126563lin_ty
linums838283linums
liny78141323lin__y
lioness739093lioness
lip514755803li___p
lipe66839733lipe__
liqueur1642923liqueur
lire47845293lire__
lisp68926873li__sp
lite47054543lite__
liter54736343lite_r
liters65429873liters
litmus836323litmus
litu47631563li_tu_
live76540993live__
lived95523723live_d
lively123310813lively
liven85021733live_n
livens94314893livens
liver85132963live_r
livers94927823livers
livery124910893livery
lives86133193live_s
livest95315733livest
lockup1434763lockup
lone45849133lone__
lonely92912463lonely
loner55431033lone_r
loners64225803loners
lookup1233453lookup
loup66028433l__oup
lune47140493lune__
lunes55337773lune_s
lunet56835423lune_t
lunets66914763lunets
luteum837783luteum
lyceum1343953lyceum
makeup1434863makeup
mine67256153mine__
mined85333353mine_d
miner76933543mine_r
miners84126633miners
mines75651953mine_s
minium106014413minium
minuet82621033minuet
minus75223933min_us
mixup1636773mi_xup
neap66927013__neap
neep65728313__neep
neuk87416603__neuk
neum66723083__neum
nine45842173nine__
nines55937343nine_s
ninety9510963ninety
oilcup1044253oilcup
pickup1655633pickup
pileum10399513pileum
pileups11365433pileups
pileus84514943pileus
pine67755713pine__
pineal84817683pineal
pined85935323pine_d
pinene82915643pinene
pinery115214283pinery
pines76048863pine_s
pinesap1164723pinesap
pineta85815563pineta
pinetum1145553pinetum
piney105727503pine_y
pinups1037413pin_ups
sannup836563sannup
sendup9106343sendup
sieur5911893si_eur
sine46560623sine__
sines55954823sine_s
sinew84718923sine_w
sinews94210623sinews
sinewy12667513sinewy
sinful938803sinful
sinus55523853sin_us
sirup74014913si_rup
situp74414063si_tup
slipup1034503sli_pup
sneap75514823_sneap
sunup7313053sun_up
takeup1234583takeup
tine45855133tine__
tinea54923153tine_a
tineal66216153tineal
tineas64616473tineas
tined65434533tine_d
tineid74412013tineid
tines54848423tine_s
tinful938043tinful
tittup834203tittup
tuneups933333tuneups
vine75643683vine__
vineal94814743vineal
vined95626153vine_d
vinery124912593vinery
vines85137643vine_s
vinous93914173vinous
wikiup15183533wikiup
windups1334783windups
wine74953423wine__
wined94434183wine_d
winery125014273winery
wines85546863wine_s
winesap1264443winesap
winesop1264233winesop
winey115325433wine_y
zine137036153zine__
zineb165614143zine_b
zinebs17606803zinebs
zines145232653zine_s

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163066.67316891.4
3Display Results3063060.0933290.3
 (SQL Overall)1786913066.90625874.7
 
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.