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

339 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
quipu16481164(None) 
quip154818621quip_
quippu19344861quippu
quips164713371quips
quipus17458001quipus
equip16467262equip_
equips17387192equips
pupu87620712pu_pu
quick204311062quick
quid144922352qui_d
quids154917462quids
quiet144530732quiet
quiff201111552quiff
quill148413762quill
quilt144125102quilt
quin135823922qui_n
quins144819852quins
quint144529902quint
quippus20363542quippus
quippy22384262quippy
quire144917122quire
quirk184011002quirk
quirt144624232quirt
quit136136512qui_t
quite144621462quite
quits144122352quits
quiz224920002qui_z
adieu6417423adieu
blip88322773blip_
blips95615783blips
bubu85022663bu_bu
build84413353build
built74325923built
bump106228243bump_
bumph144911983bumph
bumps115921143bumps
bumpy144715053bumpy
buppy144810073buppy
burp85028883burp_
burps94220173burps
chip116726423chip_
chips125721253chips
chiru105317153chiru
clip86924003clip_
clips96018303clips
clipt96324273clipt
coypu12349873coypu
cripe95521143cripe
cuif96529133cui_f
cuifs104814693cuifs
cuing85420193cuing
cuish10313173cuish
culpa93610963culpa
cup76738243cu_p_
cupid103212783cupid
cuppa11398523cuppa
cuppy144710383cuppy
cups85430823cu_ps
cusp86021063cusp_
cusps94913673cusps
cutup9410093cutup
dip67848983_dip_
dips75536913_dips
dipt77339323_dipt
drip76223953drip_
drips85417233drips
dript86923873dript
dui46433383dui__
duit56241583dui_t
duits65021883duits
dump95927093dump_
dumps105220103dumps
dumpy135414753dumpy
dup67637883du_p_
dupe76630603du_pe
dups75929513du_ps
equid154610323equi_d
equids16439143equids
equine151711573equine
equity1838103equity
euripi856083euripi
euripus934623euripus
flip96324263flip_
flips105117743flips
fugu85419863fu_gu
gip67645363_gip_
gips75632923_gips
grip76127023grip_
gripe84622963gripe
grips85520133grips
gript85126173gript
gripy115115253gripy
guid66022823gui_d
guide75019883guide
guids75516153guids
guild75312753guild
guile64521133guile
guilt65125573guilt
guimpe1134723guimpe
guipure1043533guipure
guiro63712093guiro
guise64717713guise
gulp75521363gulp_
gulps84715073gulps
gulpy114612763gulpy
guppy135211273guppy
guru54623913gu_ru
haiku126113693haiku
hip86750433_hip_
hips96433703_hips
huic94818053hui_c
huipil1143773huipil
hump116228723hump_
humph155712213humph
humps126322803humps
humpy155115673humpy
hup86437813hu_p_
juice14311323juice
juicy1738283juicy
juju103612123ju_ju
juku154414853ju_ku
jump156621723jump_
jumps165116493jumps
jumpy195712813jumpy
jupe134921003ju_pe
kip97042133_kip_
kips106430513_kips
kudu95815423ku_du
kudzu19495783kudzu
kuru85521803ku_ru
lieu46534363_lieu
lip514755803_lip_
lipa68425923_lipa
lipe66839733_lipe
lips67141443_lips
litu47631563_litu
luau44824163lu_au
lulu44122883lu_lu
lump86531703lump_
lumps95624983lumps
lumpy126615913lumpy
lupin75215843lupin
lupus74512523lu_pus
mips85534073_mips
mump105425723mump_
mumps115619103mumps
mumu86022063mu_mu
nairu5413813nairu
nip56945983_nip_
nipa69421633_nipa
nips65830923_nips
ouph95618373ou_ph
output8712853output
pip78051043_pip_
pipe86434433_pipe
pips85837133_pips
pipy115421513_pipy
piu56639543_pi_u
poilu72316003poilu
pulp84825353pulp_
pulps95116483pulps
pulpy124612363pulpy
pump105726853pump_
pumps115520603pumps
pup76339883pu_p_
pupa85422813pu_pa
pupil94712983pupil
puppy114912413puppy
pups86032233pu_ps
pupus94614043pu_pus
qaid146023843qai_d
qaids156116313qaids
qi116526903q_i__
qis126934383q_i_s
qoph185911943q_oph
qua124821973qu__a
quack203812503quack
quad144618703qu_ad
quads154515843quads
quaff201311353quaff
quag144815943qu_ag
quags154613253quags
quai134420393qu_ai
quaich2047693quaich
quaigh1935463quaigh
quail144314363quail
quails153412643quails
quaint15415173quaint
quais144618393quais
quake184114643quake
quaky214310743quaky
quale143617853quale
qualm163511183qualm
quant143624813quant
quare143920543quare
quark184614123quark
quart144027853quart
quash174512163quash
quasi144015023quasi
quass144413763quass
quate144521413quate
quay164618353qu_ay
quays174612043quays
qubit164218983qubit
qubits173710343qubits
quean143612843quean
queen144312063queen
queer143712813queer
quell144311423quell
quern143610403quern
query174212083query
quest144121323quest
queue143711233queue
quey164616473qu_ey
queys17398363queys
quiche2057903quiche
quicks21389303quicks
quiets154014373quiets
quietus16286393quietus
quiffs21135433quiffs
quills153811843quills
quilts154112543quilts
quince173910133quince
quinic17319473quinic
quinin152811953quinin
quinoa15377653quinoa
quinol15357973quinol
quinsy18386353quinsy
quinta153312373quinta
quinte153414523quinte
quints154316563quints
quipped2175163quipped
quipper2095813quipper
quired163711943quired
quires154015733quires
quirks19419113quirks
quirky22435523quirky
quirts154213553quirts
quitch2036413quitch
quiver18278743quiver
quod145413623qu_od
quods154610223quods
quoin144012323quoin
quoins154110583quoins
quoit143819863quoit
quoits15379683quoits
quoll14379493quoll
quorum1736023quorum
quota145111963quota
quote143714773quote
quoth173310353quoth
qursh174110843qursh
rip56851303_rip_
ripe66038923_ripe
rips66237433_rips
ruin47430513rui_n
ruing67221053ruing
ruins55822033ruins
rump86729083rump_
rumps95922293rumps
rumpus10458893rumpus
ship95228233ship_
ships105123773ships
sip57656013_sip_
sipe67341043_sipe
sips65740103_sips
skip105421743skip_
skips115616603skips
slip67031733slip_
slipe75626133slipe
slips76023723slips
slipt76627483slipt
slipup1034503slipup
snip66424653snip_
snipe75320573snipe
snips75818013snips
squib163710493squi_b
squibs17317443squibs
squid154211903squi_d
squids16409803squids
squill1537223squill
squint154214793squint
squire155912453squire
squirm17387663squirm
squirt153812923squirt
squish1838573squish
stipe76523373stipe
suing65026363suing
suint55638183suint
suit45649873sui_t
suite54829563suite
suits55028053suits
sulu45128423su_lu
sump86331533sump_
sumps95023433sumps
sunup7313053sunup
sup57041943su_p_
supe65932763su_pe
sups64834433su_ps
swipe105217083swipe
tip56551223_tip_
tipi69924433_tipi
tips66436763_tips
trip66830393trip_
tripe75425383tripe
trips74923363trips
tui37034023tui__
tuis44829643tui_s
tulip71111693tulip_
tulips8137253tulips
tump85927033tump_
tumps95420793tumps
tup56037543tu_p_
tupik1149003tupik
tups65628763tu_ps
turps74918733turps
tutu48423173tu_tu
ulu36028703_u_lu
ump76130443_ump_
umps85721943_umps
unau43924153_unau
up47832823_u_p_
upo58925863_u_po
ups55629053_u_ps
urp56426393_urp_
urps66920473_urps
whip125521843whip_
whips134917083whips
whipt135317423whipt
wipe94830283_wipe
wushu1136993wushu
yip87241173_yip_
yipe96722173_yipe
yips95226693_yips
yup86031703yu_p_
yuppy15487913yuppy
yups96121603yu_ps
zip146636223_zip_
zips155723793_zips

Search took 4 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 Filter178691836670.1101624463.6
2DLD Change Limit836673393.34625005.1
3Display Results3393390.0764460.5
 (SQL Overall)1786913393.53250592.0
 
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.