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

249 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
shiftier143634(None) 
shifter132911081shift_er
shirtier1137941shirtier
shittier1137311shittier
driftier1275122driftier
heftier1337202_heftier
niftier10328712_niftier
shifted14359982shift_ed
shifters14319862shift_ers
shiftiest1537372shiftiest
shiftily1744552shiftily
shifting152910382shifting
shinier104113142shi_nier
sifter94516232s_ift_er
siltier73413862s_iltier
slittier837002slittier
sniffier14356642sniffier
snifter10349622snift_er
spiffier16255882spiffier
swifter13318052swift_er
thriftier1542852thriftier
whitier133311062whi_tier
wiftier13297732_wiftier
bhistie1236773bhistie_
bhisties1339003bhisties
bittier94211663_bittier
chaffier1935473chaffier
chattier1337513chattier
chertier1387873chertier
chestier1387423chestier
chichier1836023chichier
chillier13328423chillier
chinkier17377363chinkier
chintzier2342663chintzier
chippier17297673chippier
chirpier15276303chirpier
chitter124112963chi_tter
chitties13310773chitties
chuffier1934543chuffier
cliffier1633913cliffier
craftier1376193craftier
daintier937403daintier
deifier113013123deif_ier
dictier103411863_dictier
dirtier83312093_dirtier
draftier1285263draftier
drifter11348703drift_er
edifier11309263edif_ier
feistier1136193feistier
fifties132111083_fifties
flintier1136393flintier
flirtier1144893flirtier
ghostier1235383ghostier
glintier945703glintier
grifter113810493grift_er
grittier9316263grittier
guiltier934493guiltier
hafter124815883_haft_er
hastier103916623_hastier
hefter124313923_heft_er
hillier103413963_hillier
hinkier143610793_hinkier
hinter94021303_hint_er
hippier143212103_hippier
hissier103410503_hissier
hither124417253_hi_ther
hitter94419863_hi_tter
hootier104915353_hootier
huffier1637493_huffier
iffier1236763__iffier
lifter93814813_lift_er
lintier73613803_lintier
loftier1037763_loftier
miffier1537023_miffier
miltier93214963_miltier
mintier93615993_mintier
mistier93418713_mistier
mitier83620673_mi_tier
nifties102612503_nifties
nittier73512243_nittier
ossifier111196273ossif_ier
paintier1048793paintier
philter12108213philt_er
pitier84019823_pi_tier
pointier1038303pointier
reifier103414523reif_ier
saintlier954623saintlier
saltier74318633s_altier
scantier10309983scantier
scattier10267583scattier
schizier2234063schi_zier
schizzier2242253schizzier
scimiter1236143scimiter
shabbier1535183shabbier
shadier113111153sh_adier
shafted14288813shaft_ed
shafting15278683shafting
shaggier13116053shaggier
shakier143411153sh_akier
shalier103116423sh_alier
shanties113116593shanties
shatter103615703sh_atter
sheather1458233sheather
sheenier11167423sheenier
sheeter103814913sheet_er
shellier1138403shellier
shelter103214963shelt_er
sheltie10109913sheltie_
shelties111111383shelties
shelvier1464913shelvier
shicker163914823shi_cker
shielder1235183shielder
shier85428943sh___ier
shift114225143shift___
shiftiness1644793shiftiness
shiftless15265303shiftless
shifts124412943shift__s
shifty15409263shift__y
shikker13277023shi_kker
shimmer143310873shi_mmer
shimmied16294983shimmied
shimmies15287803shimmies
shindies122610503shindies
shiner93820873shi__ner
shingler12268633shingler
shinnied12345833shinnied
shinnies113010923shinnies
shipfitter1861313shipfitter
shipper143514043shi_pper
shirker143711343shi_rker
shirtiest1239333shirtiest
shirting123213613shirting
shitted114212053shi_tted
shittiest1238343shittiest
shittim1245133shitti_m
shittims1344423shittims
shitting123212663shitting
shiver124517373shi__ver
shiverer14186663shiverer
shoalier1137073shoalier
shoddier1334213shoddier
shooter103013993shoot_er
shorter103515503short_er
shortie10411343shortie_
shorties11414583shorties
shouter103213083shout_er
showier1339103sh_owier
shriekier1652963shriekier
shrimpier1643063shrimpier
shtickier1843163shtickier
shuffler17306803shuffler
shunter103611733shunt_er
shutter103712143sh_utter
shuttler1164903shuttler
shyster13116563shyst_er
sifted104313673s_ift_ed
sifters103714793s_ift_ers
sifting113014593s_ifting
silkier114411643s_ilkier
sillier74017593s_illier
sinter63625923s_int_er
sissier73711363s_issier
sister64421583s_ist_er
sitter63323383s_i_tter
sixties14310973s_ixties
sizier1514813393s_i_zier
skiddier1464193skiddier
skimpier1634293skimpier
skinnier1264893skinnier
skirter11338483skirt_er
skitter113810403ski_tter
slatier74016813s_latier
sleetier837883sleetier
slimier93212013sli_mier
slimsier1085213slimsier
slinkier12206933slinkier
slippier1256543slippier
slither104112983sli_ther
slitter73615873sli_tter
sluttier836453sluttier
smirkier1444433smirkier
smiter83616413smi_t_er
smuttier1035213smuttier
sniffer13318903snif_fer
sniffler14296833sniffler
snifters11318613snift_ers
snippier1255793snippier
snootier8278383snootier
snottier8217383snottier
snoutier8206973snoutier
snuffier14276943snuffier
softer94015313s_oft_er
softie93312483s_oftie_
softies103414613s_ofties
sootier73916613s_ootier
spicier115112463spi_cier
spiffied17234823spiffied
spiffies16277993spiffies
spikier13369983spi_kier
spinier93715163spi_nier
spirier93214073spi_rier
spitfire1343053spitfire
spitter94015183spi_tter
sportier102010053sportier
spottier10207313spottier
squiffier2442843squiffier
squintier1844473squintier
stickier14229763stickier
stiffer13319393stif_fer
stiffie13245773stiffie_
stiffies14258383stiffies
stifler102911473stif_ler
stillier868833stillier
stingier9279123stingier
stinkier12278543stinkier
stinter73614513stint_er
stuffier14336623stuffier
suiter64121813sui_t_er
surfier102613543surf_ier
sweatier1147033sweatier
swifters14277483swift_ers
swiftlet1444793swiftlet
swimmier15174313swimmier
swingier12267003swingier
swirlier1135213swirlier
swishier1434563swishier
swither133710993swi_ther
thirstier1243693thirstier
thirties1139723thirties
thistlier1243653thistlier
thither13328103thi_ther
tuftier1096603_tuftier
twistier1134813twistier
unifier102211863unif_ier
whiffer19105323whif_fer
whiffler2033483whiffler
whinier134110633whi_nier
whinnier14255013whinnier
whippier18265823whippier
whirlier14175293whirlier
whistler1496313whistler
whiter124316393whi_t_er
whither163510253whi_ther
whities133113253whi_ties
whitter139110893whi_tter
whittler1495193whittler
whizzier2233283whizzier
wittier103910823_wittier
wristier1136863wristier

Search took 10 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 Filter1786911461620.750238254.7
2DLD Change Limit1461622498.44017317.8
3Display Results2492490.0932677.4
 (SQL Overall)1786912499.28319249.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.