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

224 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
ovibos114546(None) 
avisos95410492avisos
olios54520852oli_os
oribis838832oribis
ovines94614342ovines
ovolos9257202ovolos
vibes104719952_vibes
vinos84723072_vinos
abos67734413__abos
adios65822863adi_os
adobos9438453adobos
agios65919863agi_os
alibis8311073alibis
aliyos9349533aliyos
ambos95321253_ambos
amigos94511213amigos
avians93711573avians
avion84218343avi_on
avions94114393avions
aviso85713963aviso_
avos77227013av__os
bibbs84911583_bibbs
bibs84831003_bib_s
bigos85020013_bigos
bilbos105011203bilbos
bimbos124610523bimbos
bios66335333_bi_os
biros75325133_biros
bonitos939743bonitos
bonobos1136393bonobos
bos57966813___bos
bovids1287973bovi_ds
bovines12412663bovines
bribes105918533bribes
brios74725733bri_os
carbos105122263carbos
ceibas1038503ceibas
chicos134614833chicos
chinos115018693chinos
chiros114617773chiros
cibol9512023_cibol
cibols1039523_cibols
cogitos1037613cogitos
combos125316613combos
covings134511253covings
covins114618063covi_ns
cribs94516753crib_s
dibs76233693_dib_s
didos76820823_didos
dinos65428063_dinos
dominos103210193dominos
dribs85115063drib_s
dumbos114111083dumbos
eidos65817763_eidos
enviros1034913enviros
evicts11368563evicts
evils84114263evi_ls
evites94916483evites
fibs96329513_fib_s
fidos95819063_fidos
filos86125383_filos
finos86226953_finos
folios93915463foli_os
fynbos1433283fynbos
gibes84422523_gibes
gibs75529283_gib_s
giros65722653_giros
gobos86219383_gobos
gombos114311093gombos
guiros7389093guiros
gumbos114610873gumbos
hobos106321353_hobos
ibis66519583__ibis
ivies84215763ivi_es
jibbs16609743_jibbs
jibes145520323_jibes
jibs136724093_jib_s
jumbos17379123jumbos
kibes115521123_kibes
kibosh1534263_kibosh
kilos95021483_kilos
kinos96626153_kinos
kobos115616893_kobos
lavabos1235453lavabos
lesbos837403lesbos
libs66732773_lib_s
lidos65219893_lidos
lilos55821873_lilos
limbos104712143limbos
limos75320813_limos
linos55631503_linos
lobos75921843_lobos
mambos125414493mambos
mibs85330493_mib_s
milos75428013_milos
misos76523293_misos
movies115118453movi_es
nibs65028323_nib_s
novices1238223novices
obas65730933o__bas
obes66036833o__bes
obias76116863obi_as
obis66226843o__bis
obits74617553obi_ts
oboe66822943o__boe
oboes75717713o__boes
obol65220613o__bol
obols73715863o__bols
obvious1244823obvious
odious749933odious
odists749853odists
odiums9337943odiums
ogives10367913ogives
ohias84415573ohi_as
oils46337983o_i_ls
oinks94819913o_inks
oleos55419683o_leos
olingos846013olingos
olio46829673oli_o_
olives94313953olives
ominous949033ominous
omits75018263omi_ts
omnibus1152983omnibus
onion54320973oni_on
onions64016433onions
onos46229003o__nos
opines84820703opines
opiums10307073opiums
orbits84211443orbits
orbs66626253o_rb_s
ordos65216203o_rdos
oribi7311093orib_i
oriels64914623oriels
orison6411663orison
orisons7310563orisons
orzos143311253o_rzos
osiers63412793osiers
otiose639403oti_ose
otitis63612343otitis
ottos54714323o_ttos
outbox1537463outbox
ouzos143210413o_uzos
ovals85413393ov_als
ovens86217453ov_ens
overs85224793ov_ers
oviform1544823oviform
ovine86316643ovi_ne
oviposit13375613oviposit
ovisac1153953ovisac
ovisacs1263283ovisacs
ovoids10456923ovoids
ovolo8339173ovolo_
ovules938223ovules
oxbow1734443o_xbow
oxbows1833713o_xbows
oxides14109693oxides
oxids13128973oxi_ds
oximes15107423oximes
oxims14107643oxi_ms
pisos76021063_pisos
polios84019723poli_os
primos104514423primos
provisos1336923provisos
rhinos94411123rhinos
ribes75530173_ribes
ribose839893_ribose
ribs65833033_rib_s
rovings11439493rovings
sambos104315193sambos
sibbs96211903_sibbs
sibs65933553_sib_s
silos56029433_silos
skibob1433423skibob
skibobs1542993skibobs
skimos12548803skimos
snibs75613763snib_s
soviets1087293soviets
tiros54524893_tiros
tribes85119023tribes
trigos74214173trigos
trios55528093tri_os
tripos84014923tripos
turbos8910783turbos
umbos94613073_umbos
vials85822383_vials
vibe95124513_vib_e
vibist11610583_vibist
vibrios1235813_vibrios
vices105725533_vices
videos104911373_videos
vids85627553_vi_ds
viers85621953_viers
vies75238633_vi_es
views11489643_views
vigas94817883_vigas
vigor92612423_vigor
vigors102911483_vigors
vigs85427283_vi_gs
vills86429323_vills
vims95423323_vi_ms
vinas85126343_vinas
vines85137643_vines
vino76128443_vino_
vinous93914173_vinous
viol76523603_vi_ol
viols86118103_viols
vireos94212453_vireos
vires84529683_vires
virls85618603_virls
virus85316843_virus
vis66747623_vi__s
visas84317653_visas
vises84427773_vises
visor82512833_visor
visors92912223_visors
vivas114815023_vivas
vizor173010093_vizor
vizors18328903_vizors
voices114414013voices
voids95414683voi_ds
voiles94616443voiles
vomitos12217103vomitos
winos84625043_winos
yobbos1335963yobbos

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 Limit1127162245.45320670.5
3Display Results2242240.0762947.4
 (SQL Overall)1786912245.91930189.4
 
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.