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

272 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
quiffs2113543(None) 
quaffs21125691quaffs
quiff201111561quiff_
biffs134814412_biffs
buffs135519512bu_ffs
cliffs14477592cliffs
cuffs135017492cu_ffs
cuifs104814692cui_fs
diffs126315482_diffs
duffs125216622du_ffs
gliffs13436322gliffs
griffs13398992griffs
guffs124414822gu_ffs
huffs144514742hu_ffs
jiffs185710312_jiffs
luffs114516282lu_ffs
miffs134512882_miffs
muffs134114212mu_ffs
puffs134114932pu_ffs
quaff201311352quaff_
quicks21389302quicks
quids154917462qui_ds
quiets154014372quiets
quills153811852quills
quilts154112542quilts
quins144819852qui_ns
quints154316562quints
quips164713372qui_ps
quipus17458002quipus
quires154015752quires
quirks19419112quirks
quirts154213552quirts
quits144122352qui_ts
riffs115114612_riffs
ruffs114516742ru_ffs
skiffs16327012skiffs
sniffs12378842sniffs
spiffs14328472spiffs
squiffy2542572squiffy
stiffs12389962stiffs
tiffs114414882_tiffs
tuffs115118262tu_ffs
whiffs1835082whiffs
alifs86121263ali_fs
aquifer1934883aquifer
aquifers2044393aquifers
baffs134718053_baffs
biff125026893_biff_
biffy164711133_biffy
blaffs14426623blaffs
bluffs14388373bluffs
boffs134915503_boffs
briefs115510073briefs
buff125229863bu_ff_
buffi136112203bu_ffi
buffo135112183bu_ffo
buffos14447853buffos
buffy165013373bu_ffy
builds9378493builds
bumfs125414053bu_mfs
buyoffs1842433buyoffs
caffs135417373_caffs
chaffs17459613chaffs
chiefs14509653chiefs
chuffs17427783chuffs
cliff135917133cliff_
cliffy17435243cliffy
clifts11519153clifts
coffs134916303_coffs
coiffe1447043coiffe
coiffes1546803coiffes
coifs105718703coi_fs
cuff125327993cu_ff_
cuif96529143cui_f_
curfs105122143cu_rfs
cutoffs1533603cutoffs
daffs125116423_daffs
diff116228843_diff_
difs86027323_di_fs
doffs125614333_doffs
draffs13617903draffs
drifts10499893drifts
duff114326643du_ff_
dufus94010813du_fus
duits65021883dui_ts
effs105114033__effs
equids16439143equi_ds
equines161811593equines
equips17387193equi_ps
equites162212493equites
feoffs1163703feoffs
fiefs116213703_fiefs
fifes114822393_fifes
fluffs11347783fluffs
gaffs124914653_gaffs
gifts96214963_gifts
gliff124915663gliff_
goniffs14473903goniffs
griefs10418723griefs
griff124416463griff_
griffe13438093griffe
griffes14367923griffes
grifts104511683grifts
gruffs13337453gruffs
guff114624933gu_ff_
guides84118283guides
guids75516153gui_ds
guilds8388353guilds
guiles73919283guiles
guilts74111233guilts
guiros7389093guiros
guises74216313guises
gulfs94915303gu_lfs
howffs18535043howffs
huff135623843hu_ff_
huffy174810233hu_ffy
iff96730393__iff_
iffy135312283__iffy
ifs67124243__i_fs
jiff175321413_jiff_
jiffy21458313_jiffy
juices1549423juices
kaifs125715643kai_fs
kiefs126112203_kiefs
kifs116023503_ki_fs
knifes136210213knifes
kufis1249253ku_fis
lifts85719063_lifts
luff104426703lu_ff_
luffa11409023lu_ffa
luffas12337483luffas
miff125625063_miff_
miffy163910203_miffy
muff124723863mu_ff_
naffs116213963_naffs
naifs87617423nai_fs
neifs85613043nei_fs
offs107117013__offs
pouffs14418123pouffs
puff125525433pu_ff_
puffy164410753pu_ffy
putoffs1543333putoffs
qaids156116313qai_ds
qis126934383q_i__s
quacks214710103quacks
quads154515843qu_ads
quaffed2334253quaffed
quaffer2235133quaffer
quaffers2333963quaffers
quags154613253qu_ags
quaichs2144633quaichs
quaighs2043493quaighs
quails153412643quails
quais144618393qu_ais
quakes194013343quakes
qualms17317243qualms
quants153614143quants
quarks193810913quarks
quarts154715933quarts
quass144413763qu_ass
quays174612043qu_ays
qubits173710353qubits
queans153110753queans
queens15338873queens
queers153510773queers
quells15359703quells
querns15307943querns
quests153310353quests
queues153510193queues
queys17398363qu_eys
quiche2057903quiche
quiches2139333quiches
quick204311063qui_ck
quid144922353qui__d
quiet144530733qui_et
quietus16286393quietus
quill148413773qui_ll
quilt144125103qui_lt
quin135823923qui__n
quince173910133quince
quinces183210433quinces
quinic17319473quinic
quinin152811953quinin
quinins162811293quinins
quinoa15377653quinoa
quinoas16337873quinoas
quinol15357973quinol
quinols16297243quinols
quinsy18386353quinsy
quint144529903qui_nt
quinta153312373quinta
quintas163611713quintas
quinte153414523quinte
quintes164114713quintes
quip154818623qui__p
quippu19344863quippu
quippus20363543quippus
quippy22384263quippy
quipu164811643qui_pu
quire144917133qui_re
quired163711953quired
quirk184011003qui_rk
quirky22435533quirky
quirt144624233qui_rt
quit136136513qui__t
quitch2036413quitch
quite144621463qui_te
quiver18278743quiver
quivers19298753quivers
quiz224920003qui__z
quizzes2435573quizzes
quods154610223qu_ods
quoins154110583quoins
quoits15379683quoits
quolls15327303quolls
quotas15339433quotas
quotes153312463quotes
raffs115017523_raffs
reifs84819093rei_fs
riff104430103_riff_
rifs74929003_ri_fs
rifts85718643_rifts
ruboffs1543123ruboffs
ruff105127653ru_ff_
ruffe114713813ru_ffe
ruffes124112423ruffes
ruins55822033rui_ns
runoffs1343013runoffs
scoffs14347503scoffs
scuffs14419053scuffs
seifs85019333sei_fs
shifts124412943shifts
sifts84918923_sifts
skiff153612803skiff_
sluffs12349583sluffs
sniff113915863sniff_
sniffy15337193sniffy
snuffs12358533snuffs
spiff133616403spiff_
spiffy17326223spiffy
spliffs1533563spliffs
squibs17317453squi_bs
squids16409803squi_ds
squiffed2433733squiffed
squills1666313squills
squints16339033squints
squires163812843squires
squirms18376343squirms
squirts16348013squirts
staffs12349753staffs
stiff114219243stiff_
stuffs123810223stuffs
suints64617783suints
suites63727403suites
suits55028053sui_ts
sulfas9311563sulfas
surfs85022543su_rfs
swifts12408173swifts
tariffs1334593tariffs
teffs115111733_teffs
tiff104727723_tiff_
toffs116016723_toffs
tufas85314383tu_fas
tuff104528523tu_ff_
tufts85713273tu_fts
tuis44829643tui__s
turfs84620443tu_rfs
waffs146315473_waffs
waifs115719873wai_fs
whiff17310063whiff_
wifes114522563_wifes
yaffs145311123_yaffs

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.500357382.0
2DLD Change Limit1127162725.48320557.4
3Display Results2722720.0763578.9
 (SQL Overall)1786912726.05929491.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.