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

101 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
uplifting153496(None) 
lifting113313272__lifting
splinting1238192splinting
splitting1236562splitting
uglifying1743962uglifying
uplighting1743362uplighting
uplinking1634622uplinking
upshifting1942342upshifting
uptilting1234712uptilting
upwafting1842062upwafting
airlifting1443343airlifting
amplifying2144123amplifying
clefting14347583_clefting
delisting112710503delisting
drifting13338733_drifting
duplicating1745403duplicating
enlisting1038343enlisting
epilating12310963epilating
filiating1339243filiating
flinting123412343_flinting
flirting12319013_flirting
fliting113514613_fli_ting
flitting123010883_flitting
foliating1339253foliating
gifting123810893__gifting
glinting103210053_glinting
grifting13299263_grifting
lilting83515383__lilting
linting83820983__linting
listing84020593__listing
lofting113311313__lofting
nullifying1743493nullifying
opiating11410093op_iating
painting113614423_painting
piloting1139693_piloting
pitting103618873_p_itting
plaiting113113513_plaiting
planting113515383_planting
plating103823073_pl_ating
platting114813033_platting
pleating112916053_pleating
plighting1635563_plighting
plinking153611243_plinking
plotting113011013_plotting
pointing112813683_pointing
printing113216083_printing
pulsating1236343pulsating
purifying1835853purifying
qualifying2643973qualifying
relisting102414353relisting
resifting133512093resifting
rifting113515003__rifting
salifying1636333salifying
sealifting1444633sealifting
shifting152910383_shifting
shoplifting2052143shoplifting
sifting113014593__sifting
slitting93012583_slitting
spiffing17237083sp_iffing
spirting112913633sp_irting
spiting103917623sp_i_ting
spitting113012323sp_itting
splatting1235983splatting
splicing1338963spli_cing
splining11310773spli_ning
spoliating1366963spoliating
sprinting12310033sprinting
umlauting1243163umlauting
unfitting1336423unfitting
unifying1537553u_nifying
uniting8315823u_ni_ting
unlinking1436273unlinking
unliving1248193unli_ving
unplaiting1345503unplaiting
unshifting1743863unshifting
unwitting1335583unwitting
upbinding1544303upbinding
upcasting1434823upcasting
upclimbing1941703upclimbing
updarting1334333updarting
updating1236593up_dating
updiving1534223updi_ving
upfling1337093up__fling
upflinging1742293upflinging
upgirding1442373upgirding
upleaping1434363upleaping
uplift114610653uplift___
uplifted1454423uplift_ed
uplifter1363903uplift_er
uplifters1463283uplifters
uplifts12424773uplift__s
uploading1334663uploading
uppiling1335853uppi_ling
uprating11311113up_rating
uprighting1743463uprighting
uprising1138953upri_sing
uprooting1276903uprooting
upsetting1275563upsetting
upsizing2035413upsi_zing
vilifying1944493vilifying
yuppifying2442443yuppifying

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411017.11020905.9
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.57623586.5
 
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.