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

144 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
uplifts1242477(None) 
uplift114610651uplift_
clifts11519152_clifts
lifts85719062__lifts
spliffs1533562spliffs
splints94511742splints
splits85416412spli_ts
uplifted1454422uplifted
uplifter1363902uplifter
uplifters1463282uplifters
uplights14165052uplights
uplinks13345612uplinks
uplit76020802upli_t_
upshifts1642632upshifts
uptilts934732uptilts
upwafts1541942upwafts
airlifts1143633airlifts
alifs86121263_alif_s
aplite8316393apli_te
aplites9314933aplites
califs114915893calif_s
clefts114610163_clefts
cliffs14477593_cliffs
clift106422193_clift_
delfts10439673del_fts
delicts104012253delicts
delists84414173delists
drifts10499893_drifts
dualists958243dualists
duelists966003duelists
elints65816423_elints
enlists749393enlists
eyelifts1462753eyelifts
flints95617453_flints
flirts95411483_flirts
flits85625223_fli_ts
galiots82311323galiots
gifts96214963__gifts
gliffs13436323_gliffs
glints75714213_glints
grifts104511683_grifts
holists104413963holists
kalifs134410983kalif_s
lefts86517813__lefts
lift76942723__lift_
lilts55822803__lilts
lints57137193__lints
lists56628693__lists
lits46252493__li_ts
lofts85518363__lofts
paints85921833_paints
pilots84018873_pilots
pints75936223_p_ints
pits66348743_p_i_ts
plaints94012053_plaints
plaits83816473_plaits
plants84921803_plants
plats75531373_pl_ats
pleats85218593_pleats
pliers84715153_pliers
plies74526513_pli_es
plights13299313_plights
plinks124913263_plinks
plinth11310453_plinth
plinths1236123_plinths
plots75025673_pl_ots
points85618533_points
prints84320103_prints
pulings103511323pulings
pulis74225603puli__s
pullets94015163pullets
pulpits1137243pulpits
purists94014073purists
relicts94414593relicts
relists73817053relists
resifts10378703resifts
rifts85718643__rifts
sealifts1135473sealifts
shifts124412943_shifts
shoplifts1742763shoplifts
shrifts1335963shrifts
sifts84918923__sifts
slits56128853_sli_ts
spaits85017473spai_ts
spiffs14328473sp_iffs
spirts85317133sp_irts
spits74429553sp_i_ts
splats84817303spl_ats
splents93912133splents
splices113914383splices
spliff1438603splif_f
splines94718893splines
splint85223283splint_
split75729013spli_t_
sprints94113773sprints
sprits85122533spri_ts
swifts12408173_swifts
thrifts1335523thrifts
uglies7412323ugli_es
ugliest8410153ugliest
uglifies1246383uglifies
uglify1333913uglif_y
umlauts943193umlauts
unfits93910293unfi_ts
units54923433u_ni_ts
unlinks11307403unlinks
unlit55025463unli_t_
unlives102010953unlives
unplaits1044813unplaits
unshifts1444033unshifts
unwits9389893unwi_ts
upbeats1195733upbeats
upbinds12234813upbinds
upcasts11185643upcasts
upclimbs1641363upclimbs
updarts1034203updarts
updives1334713updives
updrafts1443203updrafts
upflings1433733upflings
upgirds11103073upgirds
upgirt9117263upgirt_
uphills1295233uphills
uplands1036943uplands
upleaps1185233upleaps
uplifting1534963uplifting
uplight13167363uplight
uplink12388713upli_nk
uploads10266503uploads
uppiles11208263uppiles
uppings12257123uppings
uppity1335103uppi_ty
uprights14145313uprights
uprises92012733uprises
uproots937143uproots
upsets8409683up_sets
upshift1545113upshift_
upshots1235193upshots
upsides10319633upsides
upsizes18297163upsizes
upticks1535153upticks
uptilt8410803uptilt_
uptimes1177553uptimes
upwaft1444943upwaft_
upwinds13224223upwinds

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271446.75019855.9
3Display Results1441440.0463130.4
 (SQL Overall)1786911446.93625762.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.