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

258 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
oxlips154443(None) 
oxlip1456881oxlip_
blips95615782_blips
clips96018302_clips
flips105117742_flips
lips67141442__lips
olios54520852o_lios
orlops847302orlops
oxalis1339222oxali_s
oxids13128962ox_ids
oxims14107642ox_ims
oxlike17307472oxlike
slips76023722_slips
tulips8137252tulips
aaliis6312903aaliis
ablins8316193ablins
alias55834603_alias
alifs86121263_alifs
allies63827673allies
alps65529243_al_ps
axils127217503ax_ils
axis116127913ax_i_s
axles125219473axl_es
axlike17388853axlike
belies84631053belies
blimps12588153_blimps
blip88322773_blip_
bliss75616913_bliss
boxlike20267073boxlike
califs114915893califs
caliph13311403caliph
caliphs1436753caliphs
chips125721253_chips
claps95626183_claps
clip86924003_clip_
clipt96324273_clipt
clops95924853_clops
codlins104116243codlins
colics104219903colics
colies84837053colies
colins85229043colins
collies94326583collies
collins93419833collins
collops112611753collops
coolies93824963coolies
coulis84018763couli_s
cowslips1543613cowslips
coxless1637743coxless
delis64928543deli_s
dips75536913__dips
doilies84017363doilies
dollies83620983dollies
dollops10287963dollops
doolies83920713doolies
doxies143917853dox_ies
doylies114512573doylies
drips85417233_drips
dulias71212743dulias
eclipse1144193eclipse
ellipse944013ellipse
equips17387193equips
exiles134816403exiles
exits125515913ex_its
felids103111623felids
fillips12298133fillips
flaps105621383_flaps
flics105418363_flics
flies85630713_flies
flip96324263_flip_
flirs85518933_flirs
flits85625223_flits
flops105920143_flops
folios93915463folios
follies103618943follies
follis93113903folli_s
foxlike21226223foxlike
galops94712623galops
genips9469943genips
gips75632923__gips
glias64618493_glias
glims87417673_glims
glops85619553_glops
goalies8316023goalies
goblins1039243goblins
gossips1035903gossips
grips85520133_grips
gulps84715073gul_ps
halids104016133halids
helios94816633helios
helps105219343hel_ps
hips96433703__hips
holies94630033holies
hollies103420813hollies
inclips1135963inclips
ixias12488373ix_ias
jalaps15299183jalaps
jalops15329593jalops
jollies143516273jollies
juleps1535623juleps
kalifs134410983kalifs
kaliph1537873kaliph
kaliphs1634293kaliphs
keleps12478813keleps
kelims1278913kelims
kelps115116423kel_ps
kilims1277903kilims
kips106430523__kips
kliks8398823_kliks
laps66848873__laps
libs66732763__libs
lids56336463__lids
lies46454193__lies
lilies63021413lilies
limps95522673__limps
lins47059053__lins
lip514755803__lip_
lipa68425923__lipa
lipe66839733__lipe
lis37162273__li_s
lisp68926883__lisp
lisps76913913__lisps
lits46252493__lits
lollies73116923lollies
lollops9227443lollops
lops66043353__lops
mips85534083__mips
molies84429513molies
mollies93420233mollies
moulins9312703moulins
moxies154317403mox_ies
nips65830923__nips
oasis56422553oasi_s
obelias9279033obelias
obias76116863o_bias
obis66226843o_bi_s
obits74617553o_bits
oblige937653oblige
obliges1037143obliges
oglers74313183oglers
ogles65223183ogl_es
ogling83211883ogling
ohias84415573o_hias
oilcups1143333oilcups
oilers64721193oilers
oilier64417233oilier
oiliest72817683oiliest
oilily93111723oilily
oiling74925313oiling
oils46337973o__ils
okapis1235393okapis
oldies7314423oldies
olds55926573o_l_ds
oleins6313523oleins
oleos55419683o_leos
oles46453473o_l_es
olio46829673o_li_o
olive84817153o_live
olives94313953o_lives
ollas54218283o_llas
omits75018263o_mits
onlays9398713onlays
online6315843online
oodlins83210513oodlins
oolite63319603oolite
oolites72817843oolites
oolith93813243oolith
ooliths10268323ooliths
oops65232673o__ops
ootids71110353ootids
ops56641253o___ps
opsins8411713opsins
optics102810183optics
orbits84211443orbits
orcins83313433orcins
orgies72316093orgies
orles55326213orl_es
orlons6411013orlons
orlop7410903orlop_
ornis54616773orni_s
orpins83614163orpins
orris54516553orri_s
osmics1036463osmics
outlies72421993outlies
ovoids10456923ovoids
owlets93110393owlets
owlish1238703owlish
owls76022933owl__s
oxalic1537093oxali_c
oxalises1538503oxalises
oxbows1833713oxbows
oxes116530723ox__es
oxeyes1635893oxeyes
oxid12815483ox_i_d
oxide131210953ox_ide
oxides14109693oxides
oxim131114053ox_i_m
oxime1498433ox_ime
oximes15107423oximes
oxtails1436383oxtails
oxters134813273oxters
ozalids1794063ozalids
palps94719563pal_ps
pilis75825203pili_s
pips85837133__pips
plies74526513_plies
plops95920333_plops
polies84034583polies
polios84019723polios
polis74731163poli_s
polyps13479763polyps
poplins11313153poplins
pulis74225603puli_s
pulps95116483pul_ps
quips164713373_quips
redips93713843redips
relics84517903relics
relies65036423relies
riflips1234163riflips
rips66237433__rips
saleps85014903saleps
salps74423243sal_ps
scrips105316033scrips
ships105123773_ships
shleps114710333shleps
sips65740103__sips
skips115616603_skips
slaps76025713_slaps
slims75423653_slims
slip67031733_slip_
slipe75626133_slipe
slipes84921413_slipes
slipt76627483_slipt
slits56128853_slits
slops75026013_slops
snips75818013_snips
solids74116403solids
splits85416413splits
strips85719653strips
sylis84316023syli_s
talipes9611603talipes
thrips11299013thrips
tips66436763__tips
toxics153910203tox_ics
toxins133314283tox_ins
toxoids1535213toxoids
trips74923363_trips
tulip71111693tulip_
uglies7412323uglies
unclips1136433unclips
unrips8199453unrips
unzips17175273unzips
walies95324523walies
whips134917083_whips
woolies104117363woolies
xis106935333_x_i_s
yelps105712993yel_ps
yips95226703__yips
zips155723793__zips

Search took 6 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.390458182.1
2DLD Change Limit1127162585.06022275.9
3Display Results2582580.0803225.0
 (SQL Overall)1786912585.53032313.0
 
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.